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 Data>Filter>Advanced Filter, there is a copy unique box in
> there.
>
> --
> HTH
>
> Bob Phillips
>
> "seeking improvment" <seeking improvment@discussions.microsoft.com> wrote in
> message news:4C8DB9B1-CEED-4C63-ADF0-9F3FD95C8FB6@microsoft.com...
> > 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".
>
>
>