H
Howard Brazee
I have a spreadsheet where I need to pick up the top 10 scores.
B17 marks them with:
=IF(AND(G17>0,D17<11,C17<21),"0","")
D17 has:
=IF(AND(F17>='Performance Statistics'!$E$7,F17<='Performance
Statistics'!$E$8,G17>0),RANK(L17,$L$4:$L$502),500)
Trouble is, there was a 3-way tie for 9th, and 11 scores were
selected, messing up other calculations that were expecting 10.
How can I fix this?
B17 marks them with:
=IF(AND(G17>0,D17<11,C17<21),"0","")
D17 has:
=IF(AND(F17>='Performance Statistics'!$E$7,F17<='Performance
Statistics'!$E$8,G17>0),RANK(L17,$L$4:$L$502),500)
Trouble is, there was a 3-way tie for 9th, and 11 scores were
selected, messing up other calculations that were expecting 10.
How can I fix this?