latest entry

[billandrus]

How do I get the last entry in a fixed column? For example:

The column is 10 rows.

Row 1 is the number 25
Row 2 is 30
The rest are blanks.

What is the function to pick the latest entry that being 30.

Then when row 3 changes to 45 then the "choose" function would select the latest entry that now being 45.

Thanks

Bill Andrus

[Peo Sjoblom]

If there are no blanks

=INDEX(A:A,COUNT(A:A))

if there are blanks

=LOOKUP(2,1/(A1:A1000<>""),A1:A1000)


--

Regards,

Peo Sjoblom


"billandrus" <[email protected]> wrote
in message news:[email protected]...
>
> How do I get the last entry in a fixed column? For example:
>
> The column is 10 rows.
>
> Row 1 is the number 25
> Row 2 is 30
> The rest are blanks.
>
> What is the function to pick the latest entry that being 30.
>
> Then when row 3 changes to 45 then the "choose" function would select
> the latest entry that now being 45.
>
> Thanks
>
> Bill Andrus
>
>
> --
> billandrus
> ------------------------------------------------------------------------
> billandrus's Profile:
http://www.excelforum.com/member.php...o&userid=27945
> View this thread: http://www.excelforum.com/showthread...hreadid=478927
>

[Bob Phillips]

=INDIRECT("B"&MAX(IF(NOT(ISBLANK(B1:B10)),ROW(1:10))))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"billandrus" <[email protected]> wrote
in message news:[email protected]...
>
> How do I get the last entry in a fixed column? For example:
>
> The column is 10 rows.
>
> Row 1 is the number 25
> Row 2 is 30
> The rest are blanks.
>
> What is the function to pick the latest entry that being 30.
>
> Then when row 3 changes to 45 then the "choose" function would select
> the latest entry that now being 45.
>
> Thanks
>
> Bill Andrus
>
>
> --
> billandrus
> ------------------------------------------------------------------------
> billandrus's Profile:
http://www.excelforum.com/member.php...o&userid=27945
> View this thread: http://www.excelforum.com/showthread...hreadid=478927
>

[Gord Dibben]

Bill

=LOOKUP(9.99999999999999E+307,F:F) will return the last numeric value in
column F

=LOOKUP(9.99999999999999E+307,F1:F10) returns last numeric value in F1:F10


=LOOKUP(REPT("z",255),B2:B10000) will return the last text entry in the
range.


Gord Dibben Excel MVP

On Mon, 24 Oct 2005 15:07:51 -0500, billandrus
<[email protected]> wrote:

>
>How do I get the last entry in a fixed column? For example:
>
>The column is 10 rows.
>
>Row 1 is the number 25
>Row 2 is 30
>The rest are blanks.
>
>What is the function to pick the latest entry that being 30.
>
>Then when row 3 changes to 45 then the "choose" function would select
>the latest entry that now being 45.
>
>Thanks
>
>Bill Andrus