Thanks, for the quick responses. Does exactly what I needed to do.


"Sandy Mann" wrote in message
...
George,

Provided that you do not mean WHOLE column when you say column of numbers
try:

=LOOKUP(2,1/ISNUMBER(L1:L1000),L1:L1000)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"George W. Barrowcliff" wrote in message
m...
How can I find the last nonblank value in a column of numbers?

TIA

GWB