I've got a spreadsheet that scores ski races and displays the results. Each racer earns points based on their time, age, and ***.

To get a combined team score, rules state that the top five scores in each team are used including at least one female.

To select the top five I want to automatically include the top scoring female, then the top four racers regardless of ***. Is there a way I can accomplish this with a pivot table? I have all the data in place.

Thanks!