Prev: standard error of regression coefficient
Next: cant pass array to excel from c++ using xloper structure
From: Amy Spreadsheet Amy on 3 Nov 2009 11:15
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
From: T. Valko on 3 Nov 2009 11:28
Try this...

=LOOKUP(1E100,D4:D5000)

Adjust for a reasonable end of range: D5000

--
Biff
Microsoft Excel MVP


"Amy Spreadsheet" <Amy Spreadsheet(a)discussions.microsoft.com> wrote in
message news:4337A28E-8E71-4A1B-81E1-720A07430A92(a)microsoft.com...
> 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


From: Peo Sjoblom on 3 Nov 2009 11:29
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 Spreadsheet(a)discussions.microsoft.com> wrote in
message news:4337A28E-8E71-4A1B-81E1-720A07430A92(a)microsoft.com...
> 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


From: Jacob Skaria on 3 Nov 2009 11:34
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
From: Amy Spreadsheet on 3 Nov 2009 11:49
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
 |  Next  |  Last
Pages: 1 2
Prev: standard error of regression coefficient
Next: cant pass array to excel from c++ using xloper structure