Perhaps I should clarify a bit:
I have 9 people. I need 3 people per night during a 7 day week to work
OT based on their availability. So if person 1 can only work Tuesday
and Wednesday, obviously they can't be chosen for the rest of the week.
I need to be able to put people in a range and have the order chosen
randomly for me. Does that make sense?
---
Message posted from
http://www.ExcelForum.com/