Hi team,
I am working on a allocation project. Suppose i have n number of rows and i need to divide them into m equal number of rows and allocate m names.
In this case n = 6 (not including header).
Suppose m = 2.
What i want is --
1. that these 6 rows be divided into m=2 equal parts.
2. Under the 'Allocated to' header, the first 3 rows has value as 'A' and the next 3 rows has value as 'B'.
ID queue Number Allocated to
123 657835
456 657835
789 657835
124 657835
356 657835
786 657835
This is just an example, the number of rows keep changing. Please advice how to proceed.
Thank you,
Ron
I am working on a allocation project. Suppose i have n number of rows and i need to divide them into m equal number of rows and allocate m names.
In this case n = 6 (not including header).
Suppose m = 2.
What i want is --
1. that these 6 rows be divided into m=2 equal parts.
2. Under the 'Allocated to' header, the first 3 rows has value as 'A' and the next 3 rows has value as 'B'.
ID queue Number Allocated to
123 657835
456 657835
789 657835
124 657835
356 657835
786 657835
This is just an example, the number of rows keep changing. Please advice how to proceed.
Thank you,
Ron