Good afternoon,
This is an idea of the table that I currently have...
MON TUE WED THU FRI
PERSON 1
PERSON 2
PERSON 3
PERSON 4
PERSON 5
PERSON 6
PERSON 7
I have a set of 7 values, numbers 1 to 7. I want to distribute these between each person automatically. The values have to be different for each person on the same day, and different for the person each day. So PERSON 1 has a different value to PERSON 2 for MON. But, the value for PERSON 1 on MON is different for the same person on TUE. How would I go about doing this?
Any help would be greatly appreciated! Thanks.
Bookmarks