ExcelBanter - Data comparison and performance

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data comparison and performance (https://www.excelbanter.com/excel-discussion-misc-queries/227925-data-comparison-performance.html)

george

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

Daniel

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

All times are GMT +1. The time now is 08:52 PM.