Comparing Sales Figures, need to keep Assosciated Product Codes

[alanbarry]

Hi all,

Hope someone can help

I have sales figures for 2 different years. They are laid out as so;

2011 Sales

Country	Volume	Product Code
UK	1000	100123
USA	245	100123
Germany	566	100124
Germany	201	100125

<tbody>
</tbody>

This table is repeated for the next year, however there have been some changes to all parameters; for example,
the product code 100123 is now also shipped to Italy. The product 100125 is now shipped to Spain.

2012 Sales

Country	Volume	Product Code
UK	1222	100123
USA	500	100123
Italy	290	100123
Germany	566	100124
Spain	700	100125

<tbody>
</tbody>

My problem; I need to be able to visualize which new countries are being shipped to, and which product codes these are associated with; for example, I need Italy 100123 to be highlighted to me as a new destination for that product code.

The actual tonnage sold itself is irrelevant, I just need to know if it is >0.

Is there a way to compare these two data sets easily? My knowledge of Excel is not great, my apologies if this is a very basic thing to ask! The file is several thousand lines items long, hence the need for some automation.

Many many thanks to anyone that may help!

Alan.

 

[Andrew Poulsom]

With the data you posted in the range A1:C13, select A9:C13 and apply Conditional Formatting with the formula:

=ISERROR(MATCH($A9,$A$3:$A$6,FALSE))

with the Format of your choice.