Prev: IF, INDEX and MATCH
Next: the criteria pane and table panes have disappered.
From: Steve on 22 Mar 2010 09:20
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
From: Mike H on 22 Mar 2010 09:25
Hi,

This returns the rightmost entry in the row A2:M2

=LOOKUP(2,1/(A2:M2<>""),A2:M2)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Steve" wrote:

> 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
From: Bernard Liengme on 22 Mar 2010 09:34
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" <Steve(a)discussions.microsoft.com> wrote in message
news:5C04747A-2B9B-43F6-85CE-67F7566DAA8C(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: IF, INDEX and MATCH
Next: the criteria pane and table panes have disappered.