Jay

Try this formula to get last filled cell(numeric or text) in column A

=LOOKUP(2,1/(A1:A65535<""),A1:A65535)


Gord Dibben MS Excel MVP

On Thu, 05 Jul 2007 12:23:11 -0400, Jay Somerset wrote:

On Thu, 5 Jul 2007 10:02:58 -0500, "Chip Pearson"
wrote:

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 .

I was intrigued by your formula, so I tried it. For me, it returns the
largest value in the range, not the last entered. If you replace MAX
with MIN, it returns the smallest.

How is your formula supposed to work? I can't figure out the logic.
Thanks.