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

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.
 
M

Max

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 #
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to use filtering in a row and in a column 2
Report with a Gap Every Nth row ? 2
How do I copy data from one cell to the next occurrence of data? 5
How to get the row number of new value in a column??? 1
First non blank number in a row 4
Find Copy Paste 1
I am getting incorrect responses to complicated Count() Query... 14
How do I add a column of cells, but IF a row has (), subtract? 4

Top