# Archery scorecard for Top 4 Female scores then the Top 8 scores

• I am trying to write a formula which will List, Rank, and calculate scores and archers. The problem I am having is to weave a formula into other formulas that will show the Top 12 scores WITH 4 of them being Female. Even if the Females are not the in top 12 scores, they should make at least 4 out of the 12 scores.

• Re: Archery scorecard for Top 4 Female scores then the Top 8 scores

so, top 8 male, and somewhere between those (if they fit, if not, at the end) the top 4 females?

Regards

Ford

• Re: Archery scorecard for Top 4 Female scores then the Top 8 scores

Quote from FDibbins;767293

so, top 8 male, and somewhere between those (if they fit, if not, at the end) the top 4 females?

Yes. forum.ozgrid.com/index.php?attachment/68566/ Here is what I have so far. The list to the right is extracting data from the left. I want to list the 12 top Archers in score order, but have to have at least the 4 top female scores.

## Files

• Re: Archery scorecard for Top 4 Female scores then the Top 8 scores

What are the chances that you would have more than 4 ladies in the top 12?

Regards

Ford

• Re: Archery scorecard for Top 4 Female scores then the Top 8 scores

That would be a possibility. I need the top 12 scores, but AT LEAST 4 have to be female. So, if I had any female scores higher than a male score OR any other female scores in the top 12, that would suffice. I could have 6 male and 6 female top scores, as long as I had at least 4 females.

• Re: Archery scorecard for Top 4 Female scores then the Top 8 scores

Nothing? Harder than I thought.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!