Ignore Duplicates in Counts

Hey,

I have a list in which I have a number set up for people. This is a list that counts the people regardless of how many go to see different staff members. Each person is allowed to come multiple times and receive help from different people. I don't need to know how many times they came but just who came.

How do I work it so that when I want a count, it ignores duplicate id numbers? I don't want them erased, because I still need them to be recorded but I do need the number of people who requested our service.

I use Excel rarely so I'm not very familiar with the functions. I use the standard formulas set up with it.

Thanks.

Originally Posted by dfq

Hey,

I have a list in which I have a number set up for people. This is a list that counts the people regardless of how many go to see different staff members. Each person is allowed to come multiple times and receive help from different people. I don't need to know how many times they came but just who came.

How do I work it so that when I want a count, it ignores duplicate id numbers? I don't want them erased, because I still need them to be recorded but I do need the number of people who requested our service.

I use Excel rarely so I'm not very familiar with the functions. I use the standard formulas set up with it.

Thanks.

Try this:

If A1:A10 is your data range enter the following formula in B1.

=Sumproduct((A1:A10<>"")/Countif(A1:A10,A1:A10&""))

Enter

HTH.