Sorting customer names

S

seeking improvment

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".
 
B

Bob Phillips

Take a look at Data>Filter>Advanced Filter, there is a copy unique box in
there.
 
S

seeking improvment

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
 
S

seeking improvment

Anne,

Thank you very much for your reply. I apoligise for the delay in saying
thank you. The link you posted had all the answers I have been searching for.

You have no idea how happy this makes me.
 
Top