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 |
Finding Duplicate files in Excel 2007
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! "hardnsoft" wrote: 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 |
Finding Duplicate files in Excel 2007
Thanks Danny after getting help it worked just like I wanted it to do.
-- Harry "dannyrblock" wrote: 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! "hardnsoft" wrote: 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 |
Finding Duplicate files in Excel 2007
Hello!
maybe this small add-in for Excel which i have found recently can help: http://www.office-excel.com/excel-ad...ta-finder.html Best regards, Eugene "hardnsoft" wrote in message ... 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 |
All times are GMT +1. The time now is 03:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com