duplicate Values

[ravi_m5_2000]

Hi Friends,

I have list of employees as mentioned below :

Alex
John
Home
Alex
Sweet

Now what I want is, I want to calculate total number of employees, if I calculate the above employees - excel will show me 5 but actual it is 4 because Alex is coming in 2 times, so what I want is excel will calculate the total number of employees excluding duplicate entries.

Could you please help me in this.

Regards
Ravi

[DonkeyOte]

You can count along the lines of:

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