example: I have 1000 sorted records. I have 5 employees. I want 1st
record to go to emp 1; 2nd record to emp 2 ... 5th record to 5th emp.
Then I want to start new assignment of records: emp 2 gets 1st rec;
emp 3 gets 2nd rec.... emp 1 gets 5th record, thus rotating which emp
gets first record. ...

Maybe something like this would help:
=CHOOSE(MOD(ROW(),5)+1,"Pat","Leslie","Evelyn","Ch ris","Glenn")

After reading the original post more carefully, I noticed that the
"CHOOSE" should've been more like this:

=CHOOSE(MOD(ROW()-1+INT((ROW()-1)/5),5)+1,
"Pat","Leslie","Evelyn","Chris","Glenn")