In A1, enter

=RANDBETWEEN(1,UpperLimit)

where upperlimit is the count of your regions.

Then copy down for as many rows as you have "number of spins"

Then in another column, say C2:C...., type 1, 2, 3, 4,....UpperLimit, and next to this column, use
the formula

=COUNTIF(A:A,C2)

and copy down to get a count.

Everytime you recalc, the numbers will change.

HTH,
Bernie
MS Excel MVP


"ghost" wrote in message
...
Spinner is spun 100 times, what is the frequency of spins that land in each
100 regions? (Each rang should be in color) how can I make that in Excel
please?
One more thing,
How to make spreadsheet that compares two fractions?