Hi, I wanted to add a custom index so each 111, 222, 333, 444, etc. or 123, 123, 123, 123, etc ,
So in excel either
QUOTIENT(SEQUENCE(25,,0,1),3)+1
or MOD(SEQUENCE(25,,0,1),3)+1
others are available 樂
so I though I could use the index column and just increase by a fraction and round; but the problem is
1.8 + 0.2 is not 2, it's 1.9999999999999998
so it throws everything out, so without grouping or creating a list in generate and then putting together is there another approach or way around this?
One quick fix I've since found is to add a small number so ;
Richard.Please Login or Register to view this content.
Bookmarks