Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to know the difference value of a cell from previous value.
hi everybody,
Please solve this problem. thanks. A1 B1 C1 D1 E1 F1 G1 H1 I1 A2 January 2007 A3 A4 A5 Total UI MF Tr UN Con Acq PT A6 34 10 2 3 1 1 3 14 A7 1. In January'2007 (B2,C2) the status of the report is (C6:I6). 2. The status (C6:I6) will change every month. But the Total (B6) never change. 3. In February'2007 (B2,C2) the status is different than January'2007. 4. I want to display difference status from January to February in the following range of C7:I7. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to know the difference value of a cell from previous value.
If you've got your January values in C6:I6, put your February values in
C7:I7, and then the January to February difference in C can be obtained using the formula =C7-C6, and copy the formula across to cover through to I. -- David Biddulph "ramulu" <u31857@uwe wrote in message news:6e06fd5955203@uwe... hi everybody, Please solve this problem. thanks. A1 B1 C1 D1 E1 F1 G1 H1 I1 A2 January 2007 A3 A4 A5 Total UI MF Tr UN Con Acq PT A6 34 10 2 3 1 1 3 14 A7 1. In January'2007 (B2,C2) the status of the report is (C6:I6). 2. The status (C6:I6) will change every month. But the Total (B6) never change. 3. In February'2007 (B2,C2) the status is different than January'2007. 4. I want to display difference status from January to February in the following range of C7:I7. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to know the difference value of a cell from previous value. | Excel Worksheet Functions | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |