Hello everyone,
I am stumped on how I should go about tackling this. I will like to avoid macros or VBAs.
Basically I am creating a roster that changes daily. To be fair, the roster needs to rotate among everyone equally. For holiday's, the roster also needs to rotate equally but still have the total count to be equal among everyone at the end of the year. I do not want the roster list to have back to back names.
My solution attempt.
1) first start with holidays and have a index mod function select a name from the input list, and populate it on the holiday list. (works)
2) Then Put these names that were selected on holidays, into the daily roster. (works)
3) Now Count the roster and see how many times each person is listed. (works)
4) Then using MIN function, find the name who has the fewest count. (works)
5) Put the selection from #4 into the roster and repeat. (Doesn't work).
The uploaded sheet is very descriptive of what I need to happen, but I just can't get this to work. My method seems to have a circular issue that could be solved with a different function, but I do not know which route to go.
Please let me know if you can think of a solution that can avoid macros or VBAs.
-best regards
Bookmarks