Count different types of cell entries linked to unique ID

[Tupelo1984]

Dear,

I wish to count the different amount of type of groups that I have linked to my unique ID.
Example: ID 123 (first column) has 4 rows with a group type (second column). In these 4 rows linked to that unique ID we have 3 different types of groups: Group A, Group B, Group C.
In the 3rd column I wish to see that count displayed in all rows of that unique ID so I can pivot the data. In this example Unique ID 123 has 3 group types. Hope someone can help! Thanks

Unique ID	Group	desired result Group Types count	Group value	desired result group value types count
123	Group A	3 Group types	Bells	3 group values types
123	Group A	3 Group types	Horns	3 group values types
123	Group B	3 Group types	Strings	3 group values types
123	Group C	3 Group types	Strings	3 group values types
456	Group A	1 Group types	Bells	2 group values types
456	Group A	1 Group types	Bells	2 group values types
456	Group A	1 Group types	Horns	2 group values types
789	Group A	2 Group types	Horns	3 group values types
789	Group B	2 Group types	Strings	3 group values types
789	Group B	2 Group types	Cymbals	3 group values types

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER($B$2:$B$11,$A$2:$A$11=A2)))

 

[Tupelo1984]

How about

=ROWS(UNIQUE(FILTER($B$2:$B$11,$A$2:$A$11=A2)))

Hi Fluff, this solution works great! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.