I'd like to assign leads to a list of reps as follows:
-
Give the 1st lead to rep A
-
Give 2nd lead to rep B
-
Give 3rd lead to rep C
and so forth until the list of reps is exhausted and then the next lead goes to rep A again.
I've tried using the "random sample" approach, but it does not consistently distribute leads in the right order.
Any ideas?