Hi everyone,
I am stuck with something I managed to sort out in the past, however I can't seem to find the example file I used in the past so I thought it's probably easiest to post this here.
Let me give you an example of my data:

Peter - 5 - 8.3
Frank - 4 - 7.4
Susan - 5 - 8.1
Betty - 3 - 6.9
Chris - 3 - 7.1
Claudia - 4 - 8.1

Now, imagine the first column being the name of the player, the second column the team the player is in, and the third column the score.
What I want is to find the name with the highest score in each team, so the output would be:

group 5: Peter
group 4: Claudia
group 3: Chris

As said, I had figured this out in the past with an array formula with LARGE and VLOOKUP, as I actually want to look up the top three players in a list that's a little longer than my example, so I actually need:

Rank1 group5: ...
Rank2 group5: ...
Rank3 group5: ....

Rank1 group4: ...
Rank2 group4: ...
Rank3 group4: ....

Can you help me???
Thanks so much,

Titus