how can i count the number of unique names in a list
 

I hace a list with multiple same names. in excel how can i count each name
once for a get a list total . I tried most of the count function and can get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you

how can i count the number of unique names in a list
 

This formula returns the count of unique items:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Adjust range references to suit your situation.

In your posted example, 5 names are listed, but smith is listed twice.
Consequently, there are 4 unique names.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Anvil22" wrote in message
...
I hace a list with multiple same names. in excel how can i count each name
once for a get a list total . I tried most of the count function and can
get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you

how can i count the number of unique names in a list
 

See:

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200769


"Anvil22" wrote:

I hace a list with multiple same names. in excel how can i count each name
once for a get a list total . I tried most of the count function and can get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you

how can i count the number of unique names in a list
 

Not that it's important...but, my comment should have been:

In your posted example, 6 names are listed,
but smith and west are listed twice.
Consequently, there are 4 unique names.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Ron Coderre" wrote in message
...
This formula returns the count of unique items:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Adjust range references to suit your situation.

In your posted example, 5 names are listed, but smith is listed twice.
Consequently, there are 4 unique names.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Anvil22" wrote in message
...
I hace a list with multiple same names. in excel how can i count each
name
once for a get a list total . I tried most of the count function and can
get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you

how can i count the number of unique names in a list
 

Ron,
It worked - greatly appreciated- thank you.

"Ron Coderre" wrote:

Not that it's important...but, my comment should have been:

In your posted example, 6 names are listed,
but smith and west are listed twice.
Consequently, there are 4 unique names.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Ron Coderre" wrote in message
...
This formula returns the count of unique items:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Adjust range references to suit your situation.

In your posted example, 5 names are listed, but smith is listed twice.
Consequently, there are 4 unique names.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Anvil22" wrote in message
...
I hace a list with multiple same names. in excel how can i count each
name
once for a get a list total . I tried most of the count function and can
get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you

how can i count the number of unique names in a list
 

Gary,
Neat answers. Thanks
Dick

"Gary''s Student" wrote:

See:

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200769


"Anvil22" wrote:

I hace a list with multiple same names. in excel how can i count each name
once for a get a list total . I tried most of the count function and can get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you

how can i count the number of unique names in a list
 

You're very welcome......I'm glad I could help.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"Anvil22" wrote in message
...
Ron,
It worked - greatly appreciated- thank you.

"Ron Coderre" wrote:

Not that it's important...but, my comment should have been:

In your posted example, 6 names are listed,
but smith and west are listed twice.
Consequently, there are 4 unique names.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Ron Coderre" wrote in message
...
This formula returns the count of unique items:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Adjust range references to suit your situation.

In your posted example, 5 names are listed, but smith is listed twice.
Consequently, there are 4 unique names.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Anvil22" wrote in message
...
I hace a list with multiple same names. in excel how can i count each
name
once for a get a list total . I tried most of the count function and
can
get
them to work.
smith
jones
smith
west
east
west
total 5 names.

Thank you