Hi Excel forum

I have a spreadsheet for darts, I have everything I need, but one part is not working.
a B AG
Name Gender Total
Brian m 28
Jenifer f 30
This is the formula in column A =IF(ISBLANK('Individual Standings'!A6)=FALSE,('Individual Standings'!A6),"")
This is the formula in column AG =SUM(C6:AF6)

There are cells C to AF that have the data week by week throughout the season of darts. I need to obtain the top six players of male and female players. The group has about 60 players in the name column A, and the formula in this column gets the info from another sheet in the same workbook. In the gender column has just f or m no formula. In the AG column it has a formula where it totals the C to AF columns. What I would like to do is calculate the top 6 players for each gender male and female.

Thank you in advance. Doug