One more.....

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

Will return last data in column A...text or number.


Gord Dibben MS Excel MVP

On Sun, 7 Jan 2007 16:11:00 -0800, Office Jnr
wrote:

Thanks Don

"Don Guillett" wrote:

Look for any number larger than possible in your column. Chg to "zzzzzzz"
for letters.

=LOOKUP(999999,K:K)

--
Don Guillett
SalesAid Software

"Office Jnr" wrote in message
...
I have a list and i need a formula to pick the last entry in a list. Can
anyone help pleez