I have two data sets that i have to reconcile/compare. In the workbook attached these are Data1 and Data2. I have compared them using ID1 (identification number), ID2, Price and Quantity.
There is often missing information or Prices and/or Quantities that dont match up and im trying to produce a report which summarises these mis-matches.
Using lookups i've created helper columns with 1s and 0s (where a 1 stands for 'a match found' and a '0' for no match found).
These identify:
1) if there are matching ID1's in these data sets.
2) matching ID2's
3) matching ID1's + Prices (e.g. which cant happen if there are no matching ID1's and/or no matching Prices)
4) matching ID2's + Prices
5) matching ID1's + Qtys
6) matching ID2's + Qtys
7) matching ID1's + Prices + Qtys (e.g. which cant happen if there are no matching ID1's and/or Prices and/or Qty's)
8) matching ID2's + Prices + Qtys
Ive made a MisMatchReport tab which shows what im trying to do.
In this report i would like to summarise the rows where the problems are in the data, showing what the differences are between the two datasets.
Bookmarks