Excel product comparison for two sales.

Asked By John S Michaud 50 points N/A Posted on - 03/20/2013

 

 

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 

• Status: Open
• Question Views: 702
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Luz M Terry 35 points N/A #171621

Excel product comparison for two sales.

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

About Luz M Terry

Questions
30

Answers
107

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 04/11/2013
• Question Category: MS Excel