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.