| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data comparison and performance
Hi All,
I need to compare data (%) on weekly basis and come with an anlysis improved or not, Could you please guide me on this. For instance: Week 1 Week 2 Status Week 3 status 99.00% 98.00% Down 99.00% up 98.00% 99.00% Up 97.00% down (but for the 3rd week the comparison should also include Week 1 & 2 compared against 3) -- Thanks, George |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data comparison and performance
=IF(A2=B2,"SAME",IF(A2B2,"DOWN","UP"))
=IF((A2+B2)/2=D2,"SAME",IF((A2+B2)/2D2,"DOWN","UP")) "george" wrote: Hi All, I need to compare data (%) on weekly basis and come with an anlysis improved or not, Could you please guide me on this. For instance: Week 1 Week 2 Status Week 3 status 99.00% 98.00% Down 99.00% up 98.00% 99.00% Up 97.00% down (but for the 3rd week the comparison should also include Week 1 & 2 compared against 3) -- Thanks, George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Groups of Data to Track Performance | Excel Discussion (Misc queries) | |||
| Compare Groups of Data to Track Performance | Excel Discussion (Misc queries) | |||
| Compare Groups of Data to Track Performance | Excel Discussion (Misc queries) | |||
| Compare Data to Track Changes in Performance | Excel Discussion (Misc queries) | |||
| Excel2007's performance over large amount of data( over 500,000 - 1M) | Excel Discussion (Misc queries) | |||
Hybrid Mode
