Formula to find 3 winners using 3 columns of data

[kdlenort]

I am trying to create a formula to find the winners of a tournament based on how many wins (column C), the winners score (column D) and the opponents score (column E).

The team numbers are listed in column A.
The players are listed in column B.

1 Larry/Tom 4 59 63
2 Terry/Dolan 3 66 59
3 Nick/Travis 5 69 52
4 James/Brent 5 64 61
5 Jay/George 2 50 66
6 Chris/Jordan 3 61 58
7 Del/Shawn 2 52 68
8 Kyle/Matt 4 61 55

Winners should be:
1. Team 3 with 5 wins and 69 points
2. Team 4 with 5 wins and 64 points
3. Team 8 with 4 wins and 61 points

I'm thinking possibly indexing but not sure how.

Any help is appreciated!


Thanks!!

 

[Oeldere]

instead of hardcode the 1 in the formula,

you could also refer to a row or column =>row() or column()

that could be handy if you need to copy the formula.

 

[kdlenort]

Oeldere Thanks I will give that a try.