Need Count based on group

[Peace_B1]

Looking to have another column with consective counts for each record based on the ID group.

For instance, Row 1 (A29GFL) would be 1, Row 2 would be 2, Row 3 would be 1.

The count is all based on location, so the first time an ID appears would be 1, the 2nd time it appears would be 2 etc...

[christine_assaad]

Hi @Peace_B1 

Please check the below. Cheers!

[Qiu]

@Peace_B1 
I also agree that Tile Tool is best fit in this situation.

Just for better understanding, here is a different approach.

[Tyro_abc]

Hi @Peace_B1 

You can do this using 'Running total' very easily!