I have a spreadsheet that gives rating to potential recruits. I used a index(match(large,nth))) formula to select recruits from greatest rating to smaller and of course I have duplicate ratings for different recruits.
Excell for the first set of duplicate ratings displayed the different recruits, but the second set of duplicate ratings it gave only one recruit for both 10th and 11th position. The third set of duplicate ratings it once again work perfectly, but for the fourth set of duplicate ratings it gave only one recruit for both positions. The formula was created in the first cell and copy to following cells. I have check the formulas in the cells that fail and they are following large(array, nth) properly as well. Currently I have 50 recruits and only 4 sets of duplicates. What is going on?
