Column differences [Closed]

Report
Posts
2
Registration date
Thursday December 1, 2016
Status
Member
Last seen
December 2, 2016
-
Hi.
I have 2 worksheets.
There are around 36000 rows of products on each sheet, although the sheets are not an exact match ie there are some products which appear only on sheet 2, and same on sheet 1.
Each product has a unique barcode to identify them, shown in column 1 on both sheets.
On Sheet 1, the barcoded products have a RRP in column 2
On Sheet 2 the barcoded products have an up to date RRP in column 2
I need to compare the two sheets to pull out the products whose RRPs have changed between sheet one and sheet 2, where the barcodes are the same.
Can anyone tell me how?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!