01-21-2020 10:26 PM
We have competition over 19 evening, the best 12 counts. So if someone has been 13 times or more, the worst must automatically expire.
01-22-2020 02:32 PM
If your goal is actually remove the values which are below top12, that's with VBA programming.
If to ignore in calculations that could be done with formulas. To hide such values you may apply conditional formatting rule on the first place
and white on white formatting.
Totals in vertical
totals in horizontal
In attached file I kept your calculations and added above in parallel.