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