Formula to return the last row with a non-zero value...

[RobbieC]

Hi there, I have a column with data (O1:O21) with data which could look like this:

I'm looking to return the row number which contains the last non-zero value, which in this case would be row 18.

I'm having to bear in mind that there could be zero values in amongst the data, so I can't use COUNTIF to count cells >0

If you can point me in the right direction, I'd be very grateful. Thanks very much

 

[Fluff]

How about
=LOOKUP(2,1/(O1:O21>0),ROW(O1:O21))

 

[RobbieC]

Brilliant! Thanks very much Fluff. You are a star!

 

[Fluff]

You're welcome & thanks for the feedback.