latest entry
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
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
|