neonexistence
New Member
 Joined
 Feb 25, 2021
 Messages
 1
 Office Version

 365
 Platform

 Windows
 MacOS
Hi there,
I am a high school teacher and am looking at creating an excel sheet that will act as a random number generator. As a start, I would like the code to randomly generate a number from a list of values and record it in column 1. I would then like it to continue recording each trial underneath in column 1.
Some extensions of this (not necessary but helpful) are:
1. The probability of each outcome is not equal (sum of rolling two dice)
2. Can quickly run x amount of trials (11000)
I am going to be putting a frequency table next to it, so the macro would not need to count the number of 1's, 2's etc. but merely copy them down in a big list.
Any feedback on how to achieve this would be greatly appreciated!
I am a high school teacher and am looking at creating an excel sheet that will act as a random number generator. As a start, I would like the code to randomly generate a number from a list of values and record it in column 1. I would then like it to continue recording each trial underneath in column 1.
Some extensions of this (not necessary but helpful) are:
1. The probability of each outcome is not equal (sum of rolling two dice)
2. Can quickly run x amount of trials (11000)
I am going to be putting a frequency table next to it, so the macro would not need to count the number of 1's, 2's etc. but merely copy them down in a big list.
Any feedback on how to achieve this would be greatly appreciated!