Finding Duplicate files in Excel 2007
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
|