How do I reference last cell having an entry in a column?

[USNavy Sailor]

Have a problem: trying to create formula for a cell to display the last entry
in a column. Example: column has 100 cells, 48 of which have data. The
48th entry in the column was "556". How do I get 556 displayed in a cell by
the top of the column (used as a summary)?

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html

 

[Gord Dibben]

=LOOKUP(9.99999999999999E+307,F:F)

Will return the last number in column F.

For more options on returning last cells see Bob Phillips' site.

http://www.xldynamic.com/source/xld.LastValue.html

Gord Dibben Excel MVP

On Sat, 23 Oct 2004 12:23:01 -0700, "USNavy Sailor" <USNavy

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,A:A)

Have a problem: trying to create formula for a cell to display the last
entry
in a column. Example: column has 100 cells, 48 of which have data.
The
48th entry in the column was "556". How do I get 556 displayed in a
cell by
the top of the column (used as a summary)?