Count unique values based on multiple criteria

Hello,

I need to count the number of unique values in column C for a specific tutor in column B between each month in column A. For example, Tutor B in march has 6 unique clients. Attached is a document with the data.

Any help will be appreciated!

Many thanks

Thanks, I don't think this is considering the dates though? Unless I missed something.

I need to count the unique clients that a specific tutor has between months. In march for example, tutor B has 9 rows for clients but only 6 are unique - I need a way to get that 6 for tutor B for march

Originally Posted by stephenloky

Hey,
You can use =COUNTIFS() for that

Insert this formula in cell E2 :

Please Login or Register  to view this content.

and in cells D2 and D3 put your 2 criteria. If you want more criterias just make the samething.

Any doubts, tell me.

Thanks, I don't think this is considering the dates though? Unless I missed something.

I need to count the unique clients that a specific tutor has between months. In march for example, tutor B has 9 rows for clients but only 6 are unique - I need a way to get that 6 for tutor B for march

Originally Posted by daffodil11

Please Login or Register  to view this content.

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Thanks for this but the date is being ignored? How would I change the formula to show for dates between the 1st of march and the 31st of march?

Originally Posted by stephenloky

Please see my post,
I've attached a Pivot table by Month, you can ungroup that and see each date.

Attached another without grouping.

Many thanks for this but I this is not what I want to see. I need unique values of clients for a certain tutor

Originally Posted by stephenloky

Please see my post,
I've attached a Pivot table by Month, you can ungroup that and see each date.

Attached another without grouping.

Many thanks for this but I this is not what I want to see. I need unique values of clients for a certain tutor

Originally Posted by stephenloky

Well, sorry for misunderstanding you.
If your worksheet it not that big, you still can use a pivot and count that....
Still thinking in a way of counting only uniques.
Hope that helps.

No worries, I still appreciate the help