Count Repeated Items Once

**longbow007** · 08-01-2010, 09:08 PM

Hello, could some one please help me with the following:

In my Excel 2003 worksheet I have employee data in range A2:AH50000

The header row is in row 2.

I am trying to count once the employee ID numbers in column C. The employee ID numbers in column C have multiple instances of the same employee ID number.

So for example, in my list of 50,000 entries (rows) there may actually only be 12,500 unique employee ID numbers.

I tried the DCOUNTA function but did not have any success.

If any one could help, that would be greatly appreciated.

Kind regards,

Chris

**stanleydgromjr** · 08-01-2010, 10:50 PM

longbow007,

In cell J2 try:
=SUMPRODUCT(--(FREQUENCY(C3:C5000,C3:C5000)>0))

**longbow007** · 08-01-2010, 11:35 PM

Thanks so much stanleydgromjr - your array formula works very well - very much appreciated,

Kind regards,

Chris

**hoho311** · 06-27-2012, 03:46 PM

Originally Posted by stanleydgromjr

longbow007,

In cell J2 try:
=SUMPRODUCT(--(FREQUENCY(C3:C5000,C3:C5000)>0))

Hello,

I have the same problem.

but in my case,I have a list of employee IDs with differnent companys, so I also need to add a creteria.

Could you help me with the formula? and I didn't really get the formula above.

Thanks a lot.

**arlu1201** · 06-29-2012, 07:33 AM

hoho311,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.