Thread: Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Office Jnr Office Jnr is offline
external usenet poster
 
Posts: 19
Default Formula

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