Would like to seek help to group the columns together.
i am using the formula : IF startswith([Count dup 2], "1") then [Row-1:Grouping]+1 ELSE [Row-1:Grouping] ENDIF
But when the number goes to 10 and 11, my number jumps.
Solved! Go to Solution.
Hi @jerometyl
Please change formula to
IF [Count dup 2]="1" then [Row-1:Grouping]+1 ELSE [Row-1:Grouping] ENDIF
This a new group is started only when count dup 2 is 1. In your previous case since 10, 11 also starts with 1 it was starting a new group.
Hope this helps : )
Thank you. It did the job. Miss out on this idea. Just didn't cross my mind. Keep thinking how it reads from 1. Thanks a lot
Happy to help : ) @jerometyl
Cheers and have a nice day!