For two sets of similar data, I would like to match on the unique identifier column, and once they have been matched, check that their corresponding values are the same. This is so I can quickly look through discrepancies in my data.
I have attached a sample for more detail.
Does anyone know what formula's I should be using?
Any help would be much appreciated.
Welcome to the forum.
You have forgotten to MOCK UP what you want to see - which column(s) do we need to be looking at and comparing? I can see the differences, but don't know which ones you want to flag. Add this to the sample workbook and attach it again, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks