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.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.