Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 620
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to know the difference value of a cell from previous value. ramulu Excel Worksheet Functions 1 February 14th 07 02:37 PM
auto populate cell based on previous cell drop down list selectio. PuzzledbyLists Excel Discussion (Misc queries) 2 September 11th 06 01:28 AM
formula, move to previous cell when the current cell=0 or empty osama amer Excel Discussion (Misc queries) 0 May 29th 06 12:18 PM
conditional cell format based on cell in same row, previous column tamiluchi Excel Worksheet Functions 7 May 3rd 06 04:11 PM
Select cell, Copy it, Paste it, Return to Previous cell spydor Excel Discussion (Misc queries) 1 December 30th 05 01:29 PM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"