Hi,
I have a table of data with approximately 5000 rows. I need to assign the same batch number to each row for an item list where another column changes its value occasionally, and may not be ordered (it can be if needed), but I need to limit the number of items in a batch to 500. The data in the Group column could be any text e.g. Time Zone
I am looking to achieve a very similar result to this thread, which gets most of the way there, but where it would increment the batch number if it reached a limit of the number of items in a batch e.g. 5 (but need to be able to change this limit by adjusting the value in the formula).
Item List | Group | Batch (limited to 5 items within a batch)
---------------|----------------|------------
Item 1 | Property A | 1
Item 2 | Property A | 1
Item 3 | Property A | 1
Item 4 | Property A | 1
Item 5 | Property A | 1
Item 6 | Property A | 2
Item 7 | Property A | 2
Item 8 | Property A | 2
Item 9 | Property B | 3
Item 10 | Property B | 3
Item 11 | Property A | 2
etc.
Appreciate the help!
I have a table of data with approximately 5000 rows. I need to assign the same batch number to each row for an item list where another column changes its value occasionally, and may not be ordered (it can be if needed), but I need to limit the number of items in a batch to 500. The data in the Group column could be any text e.g. Time Zone
I am looking to achieve a very similar result to this thread, which gets most of the way there, but where it would increment the batch number if it reached a limit of the number of items in a batch e.g. 5 (but need to be able to change this limit by adjusting the value in the formula).
Item List | Group | Batch (limited to 5 items within a batch)
---------------|----------------|------------
Item 1 | Property A | 1
Item 2 | Property A | 1
Item 3 | Property A | 1
Item 4 | Property A | 1
Item 5 | Property A | 1
Item 6 | Property A | 2
Item 7 | Property A | 2
Item 8 | Property A | 2
Item 9 | Property B | 3
Item 10 | Property B | 3
Item 11 | Property A | 2
etc.
Appreciate the help!