excell 2003

[phoenixlanmla]

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
(e-mail address removed)

thanks!

 

[Gord Dibben]

=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