From: Gord Dibben on
In D1 enter =LOOKUP(99^99,D4:D5000)

Gord Dibben MS Excel MVP

On Tue, 3 Nov 2009 08:15:01 -0800, Amy Spreadsheet <Amy
Spreadsheet(a)> wrote:

>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.