Rule to group the columns data together

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.

Output

Accepted answers

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 : )

Can you share this data in an excel file please.

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