unique names

  • Thread starter Thread starter saad
  • Start date Start date
S

saad

Hi,

I have a list of thousands of customers in column A. I
just need to find out the count of unique customer names
that appear in this list.

If also possible I would like to record all unique names
in column B - so that now column B has a list of all
customers with no repitition.

Is this possible? Tks a lot - Saad
 
a. Try this to get the unique list in col B first:

Assume col label (eg: Name) is in A1, data in A2 downwards

Select col A

Click Data > Filter > Advanced Filter

In the dialog box:
Check "Copy to another location"
Put for "Copy to:" : B1
Check "Unique records only"
Click OK

b. For the count of unique items in col B

Put in say, C1: =COUNTA(B:B)-1
 
Thnaks a lot!
-----Original Message-----
a. Try this to get the unique list in col B first:

Assume col label (eg: Name) is in A1, data in A2 downwards

Select col A

Click Data > Filter > Advanced Filter

In the dialog box:
Check "Copy to another location"
Put for "Copy to:" : B1
Check "Unique records only"
Click OK

b. For the count of unique items in col B

Put in say, C1: =COUNTA(B:B)-1




.
Click to expand...
 
Back
Top