Count unique occurrences of name
 

In Column A are the employees' names. The employee's name could be in the
column numerous times. Each employee belongs to a district, which is in
column B. So if name is John and it appears five times, then in cell C2, I
want to display 1. If there is another employee, Judy for instance that
appears 3 times, then in cell C2, I want to put 2, because there are 2 unique
names.

Can anyone help me with this formula?

Thanks in advance.

Let's say you want to count the number of times that the value entered in
cell A2 is contained in the range A2:A100.

=COUNTIF(A$2:A$100,A2)

"jhicsupt" wrote:

In Column A are the employees' names. The employee's name could be in the
column numerous times. Each employee belongs to a district, which is in
column B. So if name is John and it appears five times, then in cell C2, I
want to display 1. If there is another employee, Judy for instance that
appears 3 times, then in cell C2, I want to put 2, because there are 2 unique
names.

Can anyone help me with this formula?

Thanks in advance.

Hi,

Are there only first names (e.g., John, Judy) in column A; where are the
last names contained?
If column A has only first names, as I understand from your posting,

=COUNTIF($A$2:$A$100,"John")

Regards,
B. R. Ramachandran

"jhicsupt" wrote:

In Column A are the employees' names. The employee's name could be in the
column numerous times. Each employee belongs to a district, which is in
column B. So if name is John and it appears five times, then in cell C2, I
want to display 1. If there is another employee, Judy for instance that
appears 3 times, then in cell C2, I want to put 2, because there are 2 unique
names.

Can anyone help me with this formula?

Thanks in advance.

Try...

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

Hope this helps!

In article ,
"jhicsupt" wrote:

In Column A are the employees' names. The employee's name could be in the
column numerous times. Each employee belongs to a district, which is in
column B. So if name is John and it appears five times, then in cell C2, I
want to display 1. If there is another employee, Judy for instance that
appears 3 times, then in cell C2, I want to put 2, because there are 2 unique
names.

Can anyone help me with this formula?

Thanks in advance.

....you could run a Pivot Table to summarize the data. Once summarized, and
assuming that each employee is always in the same district, you will have one
line for each unique employee name. You can then count the unique names.

"jhicsupt" wrote:

In Column A are the employees' names. The employee's name could be in the
column numerous times. Each employee belongs to a district, which is in
column B. So if name is John and it appears five times, then in cell C2, I
want to display 1. If there is another employee, Judy for instance that
appears 3 times, then in cell C2, I want to put 2, because there are 2 unique
names.

Can anyone help me with this formula?

Thanks in advance.