Thread: How do I display the last entry in a list
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I display the last entry in a list
=LOOKUP(99^99,A:A)


for column A
--
Gary''s Student - gsnu200759


"ozsteve" wrote:

In Excel 2003, I have a list of values in a column and want to return the
last entry (ie highest row number) in the list to another cell. Can this be
done?
Reply With QuoteReply With Quote