Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always use the last number in another column for a formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always use the last number in another column for a formula
=LOOKUP(2,1/(A1:A200<""),A1:A200)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ssipiora" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always use the last number in another column for a formula
For the last numerical value, try...
=LOOKUP(9.99999999999999E+307,B2:B65536) Hope this helps! In article , ssipiora 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always use the last number in another column for a formula
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always use the last number in another column for a formula
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always use the last number in another column for a formula
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. -- ssipiora ------------------------------------------------------------------------ ssipiora's Profile: http://www.excelforum.com/member.php...o&userid=35195 View this thread: http://www.excelforum.com/showthread...hreadid=549608 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Write formula to add "1" to each number in a column | Excel Worksheet Functions |