"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.