Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shifting Calculated Result - Re-Issued
Sorry... The text on first post shifted and looks like ****. First of all
let me wish a happy new year to the group. I appreciate everything the group has done to help... and it has. Her is my recent function dilema. I'll illustrate below. I want to be able to shift a calulated value based on the date it was entered. I want to be able to post the results by date and have each result maintained in the database. Thanks for your insight. I know this should be possible. 10/22 10/23 10/24 A1 formula result 14.00 14.50 14.25 A2 formula result Results by date A3 formula result 10/22 10/23 10/24 ---------------- TOTAL: (a1..a3) 69.00 72.34 71.05** The above TOTAL ** The above is based on changes each date in the calculated TOTAL - Sony Luvy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shifting Calculated Result - Re-Issued
You probably aren't getting replies because it's not clear what you want.
Can you show us what you have and are trying to "shift". The whole SHIFT issue isn't clear to me at all. "sony654" wrote in message ... Sorry... The text on first post shifted and looks like ****. First of all let me wish a happy new year to the group. I appreciate everything the group has done to help... and it has. Her is my recent function dilema. I'll illustrate below. I want to be able to shift a calulated value based on the date it was entered. I want to be able to post the results by date and have each result maintained in the database. Thanks for your insight. I know this should be possible. 10/22 10/23 10/24 A1 formula result 14.00 14.50 14.25 A2 formula result Results by date A3 formula result 10/22 10/23 10/24 ---------------- TOTAL: (a1..a3) 69.00 72.34 71.05** The above TOTAL ** The above is based on changes each date in the calculated TOTAL - Sony Luvy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shifting Calculated Result - Re-Issued
Barb - Your right. My post is difficult to explain. Below you will see that
values are entered in to the worksheet on 10/22, 10/23 and 10/24. As the entered values each day impact the calculation of A1..A3, the sum of A1..A3 updates based on the most rercent value entered (14.25 on 10/24). As the result calculates each day, I'd like to be able to "save" the calculated value by date and post it to the right of the A1..A3 TOTAL. Is there a way to reference the value by the date it was calculated? For example, when the value for 10/24 is entered, I don't want the calculations for 10/22 and 10/23 to go away. Shift isn't a good explanation. I want to be able to trend the daily values of the calculation A1..A3. Thanks for your patience, and for giving this a second look. -- Sony Luvy "Barb Reinhardt" wrote: You probably aren't getting replies because it's not clear what you want. Can you show us what you have and are trying to "shift". The whole SHIFT issue isn't clear to me at all. "sony654" wrote in message ... Sorry... The text on first post shifted and looks like ****. First of all let me wish a happy new year to the group. I appreciate everything the group has done to help... and it has. Her is my recent function dilema. I'll illustrate below. I want to be able to shift a calulated value based on the date it was entered. I want to be able to post the results by date and have each result maintained in the database. Thanks for your insight. I know this should be possible. 10/22 10/23 10/24 A1 formula result 14.00 14.50 14.25 A2 formula result Results by date A3 formula result 10/22 10/23 10/24 ---------------- TOTAL: (a1..a3) 71.05 69.00 72.34 71.05** The above TOTAL ** The above is based on changes each date in the calculated TOTAL - Sony Luvy |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shifting Calculated Result - Re-Issued
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shifting Calculated Result - Re-Issued
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shifting Calculated Result - Re-Issued
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shifting Calculated Result | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |