View Single Post
  #6   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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.