Thread: formula for displaying only the last entry of a group of cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default formula for displaying only the last entry of a group of cells
Assuming the entries are numbers: =LOOKUP(1,1/(A1:A12<0),A1:A12)
Will no 'jump' blank cells

=LOOKUP(REPT("z",255),A1:A12) will return the last text entry of Sheet1
column A
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Steve" wrote in message
...
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