Unique Name COUNTIF Query

[SamuelT]

Hi all,

I have a spreadsheet that lists timesheet entries for the department's
employees (cells C2:C2342). I've been asked to count how many people
are on the spreadsheet (there are LOTS).

I was wondering if anyone can suggest a formula that might do this for
me. I've fiddled around with COUNTIF, but don't know how to get it to
count everytime it comes across a unique name.

Any suggestions would be greatly appreciated.

TIA,

SamuelT

 

[Bob Phillips]

=SUMPRODUCT((C2:C2342<>"")/COUNTIF(C2:C2342,C2:C2342&""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[SamuelT]

Thanks Bob.