Thread: formula for displaying only the last entry of a group of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
  
Posts: 1,814
Default formula for displaying only the last entry of a group of cells
How do you write the formula that will display only the latest entry in a
succession of entries? For example, if I have 12 months in 12 columns, and
the 13th column specifies "Last Update" , if I have made entries for Jan,
Feb, Mar so far, I need only the latest and last entry to appear in the 13th
column. When I enter April, then it would display in the 13th column cell and
so on.

Please help.
--
Thank you
Reply With QuoteReply With Quote