RANGE - Subset Query (2 Viewers)

[GUIDO22]

Hello
I have a calculation tool that displays some life cycling figures...
I need to return the block 'value' for which both the upper and lower figures are the same ie. dont contain FAIL

So in the picture attached - I want to return the value representing the highest pair of values ie, neither contains FAIL
In the picture attached, I would want returned -> 100,000

Can anyone advise a cell formula to retrieve such...?

Thank you in advance...

 

[Minty]

Think you will need to use the MaxIF() Function

MAXIFS function in Excel – find max value with multiple criteria

See how to use the Excel MAXIFS function to find the highest value with one or multiple conditions.

www.ablebits.com

 

[GUIDO22]

Think you will need to use the MaxIF() Function

MAXIFS function in Excel – find max value with multiple criteria

See how to use the Excel MAXIFS function to find the highest value with one or multiple conditions.

www.ablebits.com

Thanks - that works well...!

Only thing I need to cover now is the situation where the calculation suggests INFINITE... which is text...
So any ideas how I could encode this in the same cell formula...?
Currently I am using ..

=MAXIFS(C34:I34,C35:I35, ">=1000")

 

[Minty]

Hmm, I would possibly have a intermediate calculation that replaces the INFINITE with a value (say -1) and add that as condition?

 

[GUIDO22]

Hmm, I would possibly have a intermediate calculation that replaces the INFINITE with a value (say -1) and add that as condition?

Yeah, I had considered using a numerical value. Thanks for your input, much appreciated