Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I hope my explanation below makes sense and that someone will be able to
help me out. I want to have a worksheet that chooses a random number. The thing is, this number represents a particular "playing card". This is for a board game my friends and I have decided to try online... So this playing card is repeated 5 times in a deck of 40. What I would like to do is have numbers 1-5 represent the same playing card, 6-10 another, and so on. I want to click a button on the worksheet, have it generate the number, which draws the card and then not have that number repeat itself until I "shuffle" or reset the deck with another button. Now I have seen how the random number can be generated, and if I'm correct the number will randomly select another number if a field is double-clicked or F9(?) is selected... I want to avoid the double click and F9. I would like to have it choose that "playing card" and be able to continue with the "drawing" of cards until they are all used or I reset the deck. Could anyone assist me with this? Much appreciated. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to keep random number from changing using RANDBETWEEN? | Excel Worksheet Functions | |||
How can I get Positive values only from the random number generat. | Excel Discussion (Misc queries) | |||
Random number generator | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |