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

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

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

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