excell 2003

P

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
[email protected]

thanks!
 
G

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
 
Top