How can I find the row nr of the first number lower/ higher then a

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example
col1 col2 col3
row1
row2 3
row3 14
row4
row5 25
row6 36
row7
row8 47


For example I want to find the row of the firt number > 35
The result must be row6.
Row1, row4, row7 are empty.
 
One way

Assuming the numbers are in col A and sorted in ascending order

Enter the target number in B1: 36 (say)
Put in B2: =IF(B1="","",MATCH(B1,A:A,1))
B2 will return the desired row #
 
Back
Top