Sequence of Numbering

[Chsp2404]

I tried my best to find a solution but couldn't get an idea. Hence approaching the community page for help and guidance. 

Example:

Column A      Column B

1                         3

2                         3

3                         3

4                         3

1                         4

2                         4

1                         5

2                         5

In the above example, column A should start every time with sequential series numbers as 1,2,3, depending on number if Identical numbers in Column B.

Example, 1 - There are four 3's in Column B, accordingly I mentioned as 1,2,3,4 in column A.

Example 2 - There are two 4's in Column B, accordingly I mentioned as 1,2 in column A

Any help in this regard is highly appreciated.

Thanks,

Surya

[abacon · Accepted solution]

@Chsp2404 This workflow should get you the desired output. I did 2 options, the recordID option for if you are on 2024.2 or later and the multi-row option if you are on an older version.

Bacon

[Chsp2404]

Thank you very much for your support and workflow. It worked and the results are exactly what I wanted.

Thank you once again for saving my time

Best Regards,

Surya

[Qiu]

@Chsp2404  @abacon 
We can also use the Tile tool to do this, and also a bit twist on the Multi-row formula tool. 😁

[abacon]

@QiuThat is really great to know! Thank you for sharing the wisdom!

Bacon

[Qiu]

@abacon 
I always learn something from your flow also. Thanks.