finding the row index for the last value > than some value

Z

z.entropic

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 value>0 (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
 
A

Aladin Akyurek

z.entropic said:
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 value>0 (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
Click to expand...

What result do you expect given the above sample?
 
B

Biff

Hi!

It's not clear what you want.

Do you want the physical row location of 6.56 which might be row 22? The
virtual position which would be 3 based on your example?

Biff
 
Z

z.entropic

I finally figured out this one with COUNTIF function (only because the valued
cells happen to be contiguous)...

z.entropic
 
Top