Finding Duplicate files in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with the following column headers:
NAME ADDRESS1 ADDRESS2 CITY ST ZIP KIT PHONE DATE
This spreadsheet has about 45,000 rows. I need to find all the duplicates
for each row in the sheet. I have used the remove duplicates and if finds
about 5,000 but I need to get the data for all rows that are duplicate.

Any help with this problem is appreciated.
 
Harry,

Use the Data/Filter/Advanced Filter, check the Unique records only and Copy
to another location boxes, then select where you want to copy it to. The
help menu is pretty good with this function, too....

Good luck!
 
Back
Top