Formula to find last row in set of formulas that has a result in it?

[tonywatsonhelp]

Hi Everyone,

Ok brains gone dead pleae help.

Column P has formulas in rows 2:2000
many formulas return a "" or a zero. but I want the last row number that has something in it.
I say something as it can be a negative or positive or a text.

please help if you can

Thanks

Tony

 

[jeff_miller]

Hello Tony,

will this work?

=LOOKUP(2,1/(P1:P2000<>""),P1:P2000)

May need to have data sorted by smallest to largest to make it work?

 

[Rick Rothstein]

Hello Tony,

will this work?

=LOOKUP(2,1/(P1:P2000<>""),P1:P2000)

May need to have data sorted by smallest to largest to make it work?

No, the data does not have to be sorted in any way... that formula returns the last displayed (non-error) value no matter what it is regardless of the order of the listed items.