Numbering based on the group

[SH_94]

Dear community,

I would like to ask how we can group the following by data given and give them in sequence number.

Many thanks for the help

[DataNath · Accepted solution]

Hey @SH_94, you can do that with a Multi-Row Formula like so:

[SH_94]

Thanks @DataNath .really smart idea.My mind keep thinking of using the record ID tool which cant apply in this case.

Many thanks again for the help.