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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]Volume[/TD]
[TD]Product Code[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]1000[/TD]
[TD]100123[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]245[/TD]
[TD]100123[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]566[/TD]
[TD]100124[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]201[/TD]
[TD]100125[/TD]
[/TR]
</tbody>[/TABLE]

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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]Volume[/TD]
[TD]Product Code[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]1222[/TD]
[TD]100123[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]500[/TD]
[TD]100123[/TD]
[/TR]
[TR]
[TD]Italy[/TD]
[TD]290[/TD]
[TD]100123[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]566[/TD]
[TD]100124[/TD]
[/TR]
[TR]
[TD]Spain[/TD]
[TD]700[/TD]
[TD]100125

[/TD]
[/TR]
</tbody>[/TABLE]


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.