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

Will return the last entry in column A.........number or text.

Ignores "" created by formula.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 07:26:00 -0700, phoenixlanmla
wrote:

probably an easy formula...

i'm trying to copy the contents of the last (most recent) cell in a range to
a different column. the contents of cells after are empty, until used. this
is in a worksheet i am using to keep up with my credit card transactions, in
an easy access way, if you have any questions, please contact me by email qt


thanks!