Finding Duplicate files in Excel 2007

[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.

 

[Guest]

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!

 

[Guest]

Thanks Danny after getting help it worked just like I wanted it to do.

 

[Evgeny Grischenko]

Hello!
maybe this small add-in for Excel which i have found recently can help:
http://www.office-excel.com/excel-addins/similar-data-finder.html

Best regards,
Eugene