Try this...

=LOOKUP(1E100,D4:D5000)

Adjust for a reasonable end of range: D5000

--
Biff
Microsoft Excel MVP


"Amy Spreadsheet" <Amy wrote in
message ...
Hi,
Column D has a list that continuously grows down the column.
The list starts in D4.

I need the last value at the bottom of the list reported in D1.

The values are numbers and the numeric range is 1 thru 31 mixed.

Thank-you in advanced.
Amy