Forum Discussion
Remove
Hi,
We have competition over 19 evening, the best 12 counts. So if someone has been 13 times or more, the worst must automatically expire.
Gr. Jos
In this example, with every time a number is added, the highest 12 must remain.
Jos4841MC , in your sample I don't see "12 only", there are all results in the table.
Anyway, I don't have another solution but the one in the file attached to my previous post.
Thanks it works perfectly, is it possible that the position changes automatically according to the number of points someone gets. And it is also possible that if someone fails 12 times, they will no longer participate in the final ranking.
Thanks
If automatically that's with VBA programming. But you may add another helper column which will calculate ranks only for >=12 and perhaps to sort entire range based on it.
