pull out certain data

[tom.dickerson007]

I have a project for a school archery team.

John doe. M. 283
Jane Doe. F. 237
Johnny Doe. M. 213
Up to 24 of other names, sexes, and scores

I have range of 24 scores. I need to pull out the top 12 scores with the rank command. Then make at least 4 of those scores are male and 4 are female to achieve the teams total score.

I have the rank and calculation for total score done but I am not sure how to make sure there are at least 4 male and 4 female.

 

[isabelle]

i Tom,

this is an array formula, you must validate with the keys ctrl + maj + enter

=LARGE(IF((($B$1:$B$24="M")),$C$1:$C$24),1)

=LARGE(IF((($B$1:$B$24="M")),$C$1:$C$24),2)

etc...

isabelle

Le 2013-03-09 00:52, (e-mail address removed) a écrit :

I have a project for a school archery team.

John doe. M. 283
Jane Doe. F. 237
Johnny Doe. M. 213
Up to 24 of other names, sexes, and scores

I have range of 24 scores. I need to pull out the top 12 scores with the rank command.

Then make at least 4 of those scores are male and 4 are female to
achieve the teams total score.