Bob,

Thank you for your help this will make things easier for me. Sorry for the
delay in getting back to you.

Thank you
Candy

"Bob Phillips" wrote:

Take a look at DataFilterAdvanced Filter, there is a copy unique box in
there.

--
HTH

Bob Phillips

"seeking improvment" <seeking wrote in
message ...
I have a list of customer names that is over 6000 now and growing. I want
to
extract the names that appear only once on this list. How do I accomplish
this? There are header names "First, Last, Int, Address, City, State,
Zip,
Phone (2) and Vin".