Hi there - I have list of orders to be analyzed by reps and need to randomly assign reps. The number of orders and the available reps are not the same everyday. Based on the total orders and number of reps, need to spit equally. Same order number will get repeated in the list as well, it should have single reviewer for the day.
Table1:
| Order.Nos | Rep |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 1 | |
| 3 | |
Table2:
Expected Result:
| Order.Nos | Rep |
| 1 | AB |
| 2 | AB |
| 3 | AB |
| 4 | AB |
| 5 | BC |
| 6 | BC |
| 7 | BC |
| 1 | AB |
| 3 | AB |
Any suggestions?
