Julie, Aladin, Harlan: Thankyou very much. Now when no cells are populated
with a number 0, it returns #N/A. What can I add to return "0", if no cells
are populated. Thanks for everything on this . Tom

"JulieD" wrote:

Hi Harlan

thanks for the clarification - i tested my formula on "text" not text that
looks like a valid number. Understood about the negative numbers too.

Cheers
JulieD

"Harlan Grove" wrote in message
...
"JulieD" wrote...
just another note - the formula i initially supplied seems to work fine if
there is text in the range (ie it ignores it) - am i missing something.
...

If there's text that looks like a valid number below the last true number
in
the range, your formula would return that numberic text. Also, OP asked
for
last *positive* number, while your formula returns the last number, be it
positive, negative or zero.