Home |
Search |
Today's Posts |
#1
|
|||
|
|||
finding the row index for the last value > than some value
My data are in two columns and look like this:
A B 50 6.53 51 6.53 52 6.56 53 0.00 54 0.00 55 0.00 How can I get the row index of the last cell in col B whose value0 (the values can be in order, not necessarily descending)? I looked at ROW, ROWS, INDEX, MATCH, MAX, etc. functions, but wasn't able to put them together to get what I need. I hope this is possible w/o VBA... z.entropic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min formula not returning value from Index | Excel Worksheet Functions | |||
how do i turn the help index on again? | Excel Discussion (Misc queries) | |||
Variable values in Index function | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions | |||
index to a range of cells | Excel Worksheet Functions |