Hi,
I have been tasked with creating a tool that will randomly select 'x' amount from a list of entries and distribute to 3 named persons over a 5 day week.
Basically we have 75 servers that each need to be checked once a week (5 days) by any member of a team of 3. Therefore 15 servers per day divided by 3, giving 5 checks per person per day.
I have been able to create a simple random selection in Excel to extract 15 of the 75 listed items, but my problem is I need to ensure that once an entry has been selected, it will not be selected again until the following week.
If possible I would also like to output the data into a second sheet or table that defines the persons name and the day of the week, which could be printed at the end of the week for recording purposes. The following week the whole process would begin again.
I have limited experience with Excel so am not entirely sure what I am proposing is possible. Any information or examples would be gratefully received.
Thanks in advance.... Ben![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have been tasked with creating a tool that will randomly select 'x' amount from a list of entries and distribute to 3 named persons over a 5 day week.
Basically we have 75 servers that each need to be checked once a week (5 days) by any member of a team of 3. Therefore 15 servers per day divided by 3, giving 5 checks per person per day.
I have been able to create a simple random selection in Excel to extract 15 of the 75 listed items, but my problem is I need to ensure that once an entry has been selected, it will not be selected again until the following week.
If possible I would also like to output the data into a second sheet or table that defines the persons name and the day of the week, which could be printed at the end of the week for recording purposes. The following week the whole process would begin again.
I have limited experience with Excel so am not entirely sure what I am proposing is possible. Any information or examples would be gratefully received.
Thanks in advance.... Ben