Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet for
weight loss for a group of people if the begginging weight is in cell A1 and the next week's weight is in B1 and week after that is in C1 can I have the subtraction "follow" the numbers to show weight lost each week? : A1 B1 Formula 196 194 2 next week would be A1 B1 C1 Formula 196 194 190 4 One way: =OFFSET($A$1,0,COUNTA($A$1:$J$1)-2)-OFFSET($A$1,0,COUNTA($A$1:$J$1)-1) Adjust to suit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adjusting columns | Excel Discussion (Misc queries) | |||
Adjusting series | Charts and Charting in Excel | |||
Adjusting Macro | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Adjusting Formula | Excel Worksheet Functions |