| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I find the row nr of the first number lower/ higher then a
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. |
|
#2
|
|||
|
|||
|
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 # -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "vmv" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
10x
|
|
#4
|
|||
|
|||
|
You are welcome !
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "vmv" wrote in message ... 10x |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
| Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
| How do I change z-axis value from zero to a higher number (eg 4)? | Charts and Charting in Excel | |||
| How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Linear Mode
