Hi there
I would be extremely grateful if you could help.
I work in a prison.
There are 68 cells [1 to 68] in a unit. We have to search 3 random cells a day [this is a minimum requirement].
The main problem is that I want to generate a macro that selects 3 random cells on a daily basis until all 68 cells are randomly searched at least once a month.
e.g. On day 1, three of the 68 cells are generated randomly. The three cells to be searched are recorded in day 1.
On day 2, To keep everyone guessing, an officer will initiate a macro so that another three different cells are generated randomly and recorded in day 2.
And so on...
I can readily generate 68 random numbers in one calculation. But, I am utterly stumped on this problem and any help would be appreciated.
Bookmarks