One way:

=LOOKUP(2,1/(A1:A999<""),A1:A999)
(Make that 999 big enough to extend past the last possible row--but don't use
the whole column.)



"adeel via OfficeKB.com" wrote:

i have the range of numeric values in cloumn (lets assume "C"), in this
column some cells are empty and some are filled. i want to know a function or
set of functions that return the LAST FILLED CELL VALUE from COLUMN "C". hope
my question is clear & some one have right solution of it.

Thanks.

--
Message posted via http://www.officekb.com

--

Dave Peterson