Thread
:
Find last nonblank in a column
View Single Post
#
3
Sandy Mann
Posts: n/a
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
Reply With Quote