Delete double entries
Posted by MattH on January 07, 2002 5:24 AM
I need to delete pairs of rows that contain the same data in column A. I have 2 sets of data from seperate sources, merged together in a single sheet and sorted on Col A. The only thing in common is the account number in col A, and I have around 4000 rows. I need to be left with a set of data that is unique to my primary source, so anything in appearing in both data sources can go. Probably a simple one but I can't see it.