I have a spreadsheet formatted like the below...
id name options increment value 50 name A options A value A 50 name A options A value A 50 name A options A value A 51 name B options B value B 51 name B options B value B 51 name B options B value B 51 name B options B value B 52 name C options C value C 52 name C options C value C
I wish to auto increment each row in the increment column based on the value on the same row in the id column. Only incrementing +1 per row if the id is the same and then when the id changes, start back at 1 again. An example would look like this...
id name options increment value 50 name A options A 1 value A 50 name A options A 2 value A 50 name A options A 3 value A 51 name B options B 1 value B 51 name B options B 2 value B 51 name B options B 3 value B 51 name B options B 4 value B 52 name C options C 1 value C 52 name C options C 2 value C
The number of rows with same value in the column id could vary and the amount of rows in the spreadsheet this is required for is 6302.
Thanks in advance.
Bookmarks