Bottom value in a list
 

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

Bottom value in a list
 

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

Bottom value in a list
 

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


"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

Bottom value in a list
 

Try the below formula in D1
=LOOKUP(10^10,D4:D10000)

If this post helps click Yes
---------------
Jacob Skaria


"Amy Spreadsheet" 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

Bottom value in a list
 

Thanks Jacob it works great.
Amy

"Jacob Skaria" wrote:

Try the below formula in D1
=LOOKUP(10^10,D4:D10000)

If this post helps click Yes
---------------
Jacob Skaria


"Amy Spreadsheet" 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

Bottom value in a list
 

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