Forum Discussion
Jos4841MC
Jan 21, 2020Copper Contributor
Remove
Hello, How can i automatically remove the lowest digit from a row after 13 digits. Jos
SergeiBaklan
Jan 23, 2020Diamond Contributor
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.
Jos4841MC
Jan 24, 2020Copper Contributor
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
- SergeiBaklanJan 24, 2020Diamond Contributor
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.