Count the number of corresponding matches, in another list linked through a code

[luca.pe]

Hello together,
I have two excel tables with large sets of information.
Something like Name / Code, the Code can be the same for various Names. I would like to count for each name linked through the code how many more names there are with the same code.
I hope I was somehoe able to explain what I am trying to do. The example is attached.
BR

[AliGW]

In C3 copied down:

=COUNTIFS($C$12:$C$21,A3,$B$12:$B$21,B3)

[luca.pe]

Dear Ali,

Thank you so much for your help!

Further, how could idendify which one are corresponding (not just counting). In my example, that I receive the codes "EDFG, RFDD, JKKH, JJLK" for DHSJ.

As always, greatly appreciate your help!
"

[Glenn Kennedy]

D3, copied across & down:
=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($B$12:$B$21)/($B$12:$B$21=$B3),COLUMNS($D3:D3))),"")