Index/Match with Conditions and Duplicates

Hello All,

I am trying to create a sheet that shows the top team members for each team based on their score.

So everything works fine when there are no duplicate scores. I saw some solutions on this forum with regards to duplicate values, but none worked when I need to apply conditions to return values based on team.

The formulas I used in the attached file are:

To return team A's Top MemberINDEX($B:$B,MATCH(LARGE(IF($A:$A="A",$C:$C,""),1),$C:$C,0))

To return team A's Top Member's scoreIFERROR(LARGE(IF($A:$A="A",$C:$C,""),1)

Where Column A is team, Column B is Name, Column C is Score. there maybe duplicates in all columns

Any help is much appreciated!

thanks
dd

thank you Fotis that worked prefectly.

just our of curiosity is it possible to imbed that into a formula so i do not need to create an extra helper column?

thanks again!
dd