help finding single names from large list

I am trying to find customers, from a very large list, that have been in only one time, or new customers. Filtering helped narrow the list, but it still not useable, customers that were in several times were filtered to one visit also. I think I need to filter out customers with multiple visits. I can't seem to figure it out. Any help is appreciated.

Originally Posted by dew23456

I am trying to find customers, from a very large list, that have been in only one time, or new customers. Filtering helped narrow the list, but it still not useable, customers that were in several times were filtered to one visit also. I think I need to filter out customers with multiple visits. I can't seem to figure it out. Any help is appreciated.

Assuming that the names are in column A, in a blank column try

=IF(COUNTIF(A:A,A1)=1,A1,"")

and formula-fill that to the end of your names.

Copy this column and Paste Special = values, then sort / process etc.

hth
---