Random selection help?

Question

I have a conundrum, I have 168 room numbers that I have to randomly select from 14 rooms each month over the course of 12 months to perform maintenance checks. I am using the Random function but the issue I have is the room numbers keep getting rearranged after they have been plotted out over the course of 12 months. Once the selection is made I need the room numbers to stay put. What can I do in a formula or function that will keep the room numbers from reshuffling?

Answer 1

Thank you for your reply. What if an IF statement was placed in the formula saying like IF(A3=G, Do Nothing, otherwise process the random select statement.. G in A3 meaning I approve of the selection made. This would allow for random selection of remaining room numbers but not to include rooms already selected before. In my case, each 14 selected represent the amount needed for each month. IE., Jan = 14, Feb = 14 and so on. The random selection contains until no more 14 are selectable.

Answer 2

Thank you for your reply. What if an IF statement was placed in the formula saying like IF(A3=G, Do Nothing, otherwise process the random select statement.. G in A3 meaning I approve of the selection made. This would allow for random selection of remaining room numbers but not to include rooms already selected before. In my case, each 14 selected represent the amount needed for each month. IE., Jan = 14, Feb = 14 and so on. The random selection contains until no more 14 are selectable.

Answer 3

Hi Carl,

After entering the RANDOM formula is a cell, Press F9 instead of Enter

Regards

Answer 4

Copy the formulas and paste values.