Rule to group the columns data together

[jerometyl]

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. 

[atcodedog05]

Hi @jerometyl 

Can you share this data in an excel file please.

[atcodedog05 · Accepted 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 : )

[jerometyl]

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

[atcodedog05]

Happy to help : ) @jerometyl 

Cheers and have a nice day!