That puts efficiency in back seat. <g
George W. Barrowcliff wrote:
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
. com...
How can I find the last nonblank value in a column of numbers?
TIA
GWB
--
[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.
|