Finding Duplicates in Excel
May 29, 2008 6:25 AM Subscribe
I'm looking for an easy way to find (not remove) duplicate information in an excel database. Ideally I need to be able to easily cross reference the other records with identical information in a certain column.
posted by Classic Diner to Computers & Internet (10 answers total) 7 users marked this as a favorite
I'm sorry for going to MeFi so quickly, but you are so dog gone smart. I'm not bad at figuring out excel, and I have written a macro or two, I'm just having trouble getting started.
The database is around 5k records. The information contained in one column might have 25 duplicate records. I'd like to find and be able to cross reference the rows which have duplicates in this one column.