CountA function

[Paul]

Hi, Newbie question:

I have a list of names of people working each but doing
multiple job. I just want to count how many unique
employes worked today. In my example, it would have to
return 3 (only 3 employes worked today but accomplished 7
tasks)

Many thanks.

Paul

Task Name

Payroll Patrick
Payroll Maria
Data entry Patrick
Payroll Dennis
Data entry Dennis
Clerk Dennis
Sales Patrick

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT((B1:B20<>"")/(COUNTIF(B1:B20,B1:B20)+(B1:B20= "")))

 

[Guest]

Works Great...Many Thanks!

-----Original Message-----
Hi
try:
=SUMPRODUCT((B1:B20<>"")/(COUNTIF(B1:B20,B1:B20)+ (B1:B20= "")))

--
Regards
Frank Kabel
Frankfurt, Germany



.