Forum Discussion
Remove
Hello, How can i automatically remove the lowest digit from a row after 13 digits. Jos
What do mean by remove the lowest digit after 13 digits?
Is this an accurate representation where the cell value is = 12,345,678,910,111,212,978?
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.
I guess you any case do records for all 19, thus highest could be calculated in another column or row
as
=IFERROR(IF(LARGE($C$3:$C$21,ROW()-ROW($D$2))<LARGE($C$3:$C$21,MIN(12,COUNTA($C$3:$C$21))),0,LARGE($C$3:$C$21,ROW()-ROW($D$2))),0)In this example, with every time a number is added, the highest 12 must remain.
