2 conditions, need to know which is first

C

corona

I have a list that has at least 3 columns and is not in ascending order.
Say I have a a criteria for each column. High <24.0 and Low >18.0. How
can I determine which criteria is met first and then return the row
value (1-8). And by first, I mean counting from 1 to 8 by the first
columm.

High Low
8 23.93 22.66
7 24.46 23.35
6 24.74 22.2
5 23.22 19.81
4 18.89 17.72
3 19.44 18.74
2 18.84 18.24
1 18.4 18.94


So, the high is met at row 6 and the low is met at row 4. So I want to
return the value of 4.
 
F

Frank Kabel

Hi
try the following array formula 8entered with CTRL+SHIFT+ENTER)
=INDEX(A1:A10,MIN(MATCH(TRUE,B1:B10<24,0),MATCH(TRUE,C1:C10>18,0)))
 
Top