Excel product comparison for two sales.

Asked By 50 points N/A Posted on -
qa-featured

 

 

In my new project I want to use excel product comparison for comparable sales reports on different products, but in the same period of different years.

So how can I compare sales of one product with another?I hope anyone can help 

SHARE
Answered By 35 points N/A #171621

Excel product comparison for two sales.

qa-featured

Hello John,

Yes this is possible the picture below illustrates how it will look like. It can be quite tedious so please bear with this guide.

This only works with Microsoft Excel 2007 and onwards. You will be using quite a few formulas but they are pretty straight forward and easy.

I hope the guide helps you in what you are trying to achieve. 

Thank you,

Luz M Terry

Related Questions