Use a formula like the following array formula:

=MAX((C1:C1000<"")*C1:C1000)

Since this is an array formula, you must press CTRL+SHIFT+ENTER rather than
just ENTER when you first enter the formula and whenever you edit it later.
If you do this properly, Excel will display the formula enclosed in curly
braces { }. For more information about array formulas, see
www.cpearson.com/excel/array.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:74b850ce1f165@uwe...
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