You can use advanced filter with copy to another location option to filter
out unique records. Read more about it on this URL
http://www.contextures.com/xladvfilter01.html#FilterUR. Contextures has very
good information on other excel topics also.
--
Regards,



"PA" wrote:

Thanks for coming back to me,
If I have 2500 records, and 1000 of them should be unique, there are 1500
duplicates in addition to the 1000 that should be unique. I need to find all
identical records, some will have 1 duplicate, some 2 or more, and some may
have none.
When the process is completed, only the 1000 unique records will remain with
no duplicates.
The data is coming from a Mainframe download.
Hopefully, I have explained better
Thank you

"The Code Cage Team" wrote:


Do you want to delete all duplicates except the original and would you
want the entire row deleting?


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24057