Count unique items per client

Hello all,

I have a list of names, downloaded from client software, and then a manually maintained list of names for each, which aims to group clients with different names but the same ultimate beneficiary. Sample attached.

I am looking for a formula which will tell me the number of unique names in col B per name in col A, desired result given in col C.

So for 'APHANE - ARUP JV', result is 1 as all names in B are the same, but for 'APHANE CONSULTING CC' result is 2 as there are 2 different names in B.

I've done this in the past with a pivot table, but it was messy - perhaps I was missing a trick, can anyone offer a solution?

Thanks
Rich

Thank you very much, I'll try to figure that out.

The full list has ~35k lines, so it is churning away now.

This does the same, but with considerably fewer calculations:

=SUM(IF(FREQUENCY(IF(A$2:A$2010=A2,MATCH(B$2:B$2010,B$2:B$2010,0)),ROW(A$2:A$2010)-MIN(ROW(A$2:A$2010))+1),1))

Regards

Thank you as always XOR, that calculates much quicker.

- I should have mentioned the data size in my first post...

You're welcome.