Try this:

=LOOKUP(2,1/(1-ISBLANK(F1:F1000)),F1:F1000)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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

TIA

GWB