Bottom value in a list

[Amy Spreadsheet]

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

 

[T. Valko]

Try this...

=LOOKUP(1E100,D45000)

Adjust for a reasonable end of range: D5000

 

[Peo Sjoblom]

A couple of ways, if indeed there are no blank cells in-between you can use
this

=INDEX($D$4:$D$10000,COUNT($D$4:$D$10000))

replace 10000 with an approx number of cells that you think can be used

Another way

=LOOKUP(99^99,$D$4:$D$10000)

which will work with blank cells as well

--


Regards,


Peo Sjoblom

 

[Jacob Skaria]

Try the below formula in D1
=LOOKUP(10^10,D410000)

If this post helps click Yes

 

[Amy Spreadsheet]

Thanks Jacob it works great.
Amy

Try the below formula in D1
=LOOKUP(10^10,D410000)

If this post helps click Yes

 

[Gord Dibben]

In D1 enter =LOOKUP(99^99,D45000)


Gord Dibben MS Excel MVP

On Tue, 3 Nov 2009 08:15:01 -0800, Amy Spreadsheet <Amy