help with countif variant with multiple criteria

[bluefish44]

I'm trying to come up with a variant of a countif formula:
I want to look at column A and see how many times a unique value occurs, in the example below, John occurs 5 times.
Then I want to see how many unique values occur related to John in column B, in this example its 3 (since apple appears twice, pear appears twice, and peach appears once there are only 3 unique values.I want to put that value, in this case 3, in column C in every row that it says John. I'd like to be able to put the formula in cell C2 and drag down as many entries as there are?

Thanks in advance for any help!

A B C(formula)
John apple 3
John pear 3
John apple 3
John peach 3
Bill orange 1
Bill orange 1
Bill orange 1
Frank pear 2
Frank apple 2
John pear 3
Frank apple 2

 

[Weazel]

maybe something like...

Excel 2013

	A	B	C
2	John	apple	3
3	John	pear	3
4	John	apple	3
5	John	peach	3
6	Bill	orange	1
7	Bill	orange	1
8	Bill	orange	1
9	Frank	pear	2
10	Frank	apple	2
11	John	pear	3
12	Frank	apple	2

<tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula C2 {=SUM(IF(FREQUENCY(IF($A$2:$A$12<>"",IF($A$2:$A$12=A2,MATCH($B$2:$B$12,$B$2:$B$12,0))),ROW($A$2:$A$12)-ROW($A$2)+1),1))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[bluefish44]

thanks Weazel - do you know if this is possible without an array formula?