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)discussions.microsoft.com> wrote:

>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