Always use the last number in another column for a formula

[ssipiora]

I'd like to create a formula that always uses the last number in a column for a calculation. That way when I add new daily data I automatically get my calculation.

I'd rather not have another column doing this because I just need one number, I just need it updated every day based on additional data.

Thanks

[Bob Phillips]

=LOOKUP(2,1/(A1:A200<>""),A1:A200)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ssipiora" <[email protected]> wrote in
message news:[email protected]...
>
> I'd like to create a formula that always uses the last number in a
> column for a calculation. That way when I add new daily data I
> automatically get my calculation.
>
> I'd rather not have another column doing this because I just need one
> number, I just need it updated every day based on additional data.
>
> Thanks
>
>
> --
> ssipiora
> ------------------------------------------------------------------------
> ssipiora's Profile:
http://www.excelforum.com/member.php...o&userid=35195
> View this thread: http://www.excelforum.com/showthread...hreadid=549608
>

[Domenic]

For the last numerical value, try...

=LOOKUP(9.99999999999999E+307,B2:B65536)

Hope this helps!

In article <[email protected]>,
ssipiora <[email protected]>
wrote:

> I'd like to create a formula that always uses the last number in a
> column for a calculation. That way when I add new daily data I
> automatically get my calculation.
>
> I'd rather not have another column doing this because I just need one
> number, I just need it updated every day based on additional data.
>
> Thanks

[ssipiora]

Thanks for the tips, but neither of them are working. I have a feeling it's more due to my poor explanation so I'm going to try again.

I have a column where have calculations of daily inventory levels (prior day ending - sales + inventory added). Each day a new entry gets created in the column.

I have a separate area of the spreadsheet where I need to use the last entry in the column described above to calculate the number of days of inventory on hand.

I need to return only the value of the last cell in the column to the cell so I can then use it to calculate the days of remaining inventory on hand.

Thanks in advance.

[Peo Sjoblom]

Both formulas you were given works, Domenic's work only if the last value is
a number. So you must have applied them incorrectly,
what is the column you are using?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"ssipiora" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks for the tips, but neither of them are working. I have a feeling
> it's more due to my poor explanation so I'm going to try again.
>
> I have a column where have calculations of daily inventory levels
> (prior day ending - sales + inventory added). Each day a new entry gets
> created in the column.
>
> I have a separate area of the spreadsheet where I need to use the last
> entry in the column described above to calculate the number of days of
> inventory on hand.
>
> I need to return only the value of the last cell in the column to the
> cell so I can then use it to calculate the days of remaining inventory
> on hand.
>
> Thanks in advance.
>
>
> --
> ssipiora
> ------------------------------------------------------------------------
> ssipiora's Profile:
> http://www.excelforum.com/member.php...o&userid=35195
> View this thread: http://www.excelforum.com/showthread...hreadid=549608
>

[ssipiora]

My apologies, I had forgotten there was another row of cells at the very bottom for some totals which is what were being picked up.

Thank you all for your help.