Hello all,
I'm relatively unfamiliar with macros and in need of assistance. I have a massive data set that we know includes many duplicates BUT the syntax for the data in certain fields does not necessarily identically match the same field in the duplicate record, thus the basic sort function is not working adequately. So I am trying to remove duplicate records based on identical data in the first 2 of 5 columns in the dataset. It is set up like this:
A (Artist) B (Title) C (Claimant) D (SR #) E (Source)
I am looking for a macro that will identify and remove duplicate records based on records with identical data in columns A and B.
Any ideas? Thanks so much for any help you can provide.
Bookmarks