Help with functions or perhaps another solution to identify Bowling Tournamenthigh scores

Hi

Needing help to find the proper methods to identify and produce the high scores and winners names and their corresponding team names from a 4 team 3 game bowling tournament. Sample spreadsheet is enclosed along with the list of awards that I need to identify and produce from the data included In the spreadsheet.

Individual Score Awards are made in Two distinct categories those being Male and Female with four awards needing to be identified in each category. These awards are listed at the bottom of the spreadsheet (bottom of the data). One stipulation that is important is that one bowler can only win one high game or series award each. The awards are therefore listed in their ranked order for this purpose.

Teams are awarded medals in first, second and third place finishes based on team PINS OVER AVERAGE scores for the three games totalled (combined Pins Over Average totals of the five bowlers per team).

Thanking you in advance for any assistance you can offer.

For row 28 I would like the spreadsheet to report the highest three game total from column N and the corresponding bowler name and his team name.
For row 29 I would like the spreadsheet to report the highest three game total from column N and the corresponding bowler name and her team name.

For row 30 I would like the spreadsheet to report the highest single game score from columns F or H or L and the corresponding bowler name and his team name.
For row 31 I would like the spreadsheet to report the highest single game score from columns F or H or L and the corresponding bowler name and her team name.

I hope that answers your question clearly and you will be able to assist. Thanking you in advance.

For row 32 I would like the spreadsheet to report the highest three game POA (Pins Over Average) total from column O and the corresponding bowler name and his team name.
For row 33 I would like the spreadsheet to report the highest three game POA total from column O and the corresponding bowler name and her team name.

For row 34 I would like the spreadsheet to report the highest single POA game score from columns G or I or M and the corresponding bowler name and his team name.
For row 35 I would like the spreadsheet to report the highest single POA game score from columns G or I or M and the corresponding bowler name and her team name.

Row 28 answer would be 457 Troy Aaaaaa from Bandits # 2
Row 29 answer would be 419 Gail Ggggg from Bandits # 2
Row 30 answer would be 269 but reverts to next in line 215 Jason Ssssss on Bandits # 2 because Troy has already won an award.

Keebellah

The chart at the bottom of the original data spreadsheet pretty much drew that picture of how I want the answers from the data to appear. So therefore the explanations I included in subsequent replies were directed to AliGW who wanted an explanation of where the answers would come from.