Excel 2003.

[Fr4gm4n]

Hi,
I need to generate a set of random numbers between 1-95 ( inc ), and I also want the option to vary the amount of numbers that are produced.
I looked in excel at the random number option without much success....it did produce a random set of numbers but produced the same set when ran again :/ ( probably more down to me not configuring it properly than anything else )
Someone did say there was a formula that would do it....but didn't know what it was
Anyone know how to do this?

[jmichna]

Try this formula:
=RANDBETWEEN(1,95)

Per MS "If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in."

Note, it might be =RANDBETWEEN(0,96)

[jmichna]

Another way of doing it:
=RAND()*(95-1)+1

You may need to format cell to display only whole numbers.

[Fr4gm4n]

Cheers guys....I'll give that a go, thanks for the replies....quick as usual

Steve.

[Fr4gm4n]

Ok...used the randbetween(1,95)....worked ok, then I pasted the formula into the next 29 cells to give me 30 random numbers. Only small drawback to this is that it can generate the same number more than once in the set of 30, but since the amount of numbers is always less than 30 i have plenty to work with

Thanks jmichna

Steve.

[jmichna]

Originally posted by Fr4gm4n
...Only small drawback to this is that it can generate the same number more than once in the set of 30 ....

Steve,
Since the numbers are generated randomly, and you're doing 30 simultaneously, odds are you will see numbers duplicated in a given instance from time to time... this is by chance (random)
jmichna

[Starfury_2260]

if there is some way to keep numbers out of the group to choose from i suppose you could have each cell excepting the number used by the cells above it. i'm sure you could probably write a long complex equation that would make all the numbers random AND different but that would take too long

[Fr4gm4n]

Lol...cheers Starfury
Perhaps there is a long and complex formula and I hope it doesn't take you too long to compile it ....let me know when it's finished

Steve.