random number generator

P

pat67

Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?
 
T

Tom Hutchins

Use the RAND() function. If 1-10 are in A1:A10, enter =RAND() in cell B1 and
copy it down through B10. Recalc (F9), then sort by column B.

Hope this helps,

Hutch
 
S

Simon Lloyd

You would have to generate 10 random numbers then sort all by the colum
the random numbers are in then delete the random number column


Hey is there a way to generate random numbers like you would for
draft. In other words, i have numbers 1 through 10 and generate
random order for those?


--
Simon Lloyd

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com)
 
P

pat67

Use the RAND() function. If 1-10 are in A1:A10, enter =RAND() in cell B1 and
copy it down through B10. Recalc (F9), then sort by column B.

Hope this helps,

Hutch





- Show quoted text -


Rand() only generates between 0 and 1
 
S

Steve Dunn

Pat,

If you used RANDBETWEEN(1,10) you would be likely to get repeated numbers in
your range. You asked for the numbers 1 through 10 to be sorted in a random
order, which is exactly what Hutch's solution does - RAND() is only used for
sorting the numbers, not producing them.



Use the RAND() function. If 1-10 are in A1:A10, enter =RAND() in cell B1
and
copy it down through B10. Recalc (F9), then sort by column B.

Hope this helps,

Hutch





- Show quoted text -


Rand() only generates between 0 and 1
 
P

pat67

Pat,

If you used RANDBETWEEN(1,10) you would be likely to get repeated numbersin
your range.  You asked for the numbers 1 through 10 to be sorted in a random
order, which is exactly what Hutch's solution does - RAND() is only used for
sorting the numbers, not producing them.






Rand() only generates between 0 and 1- Hide quoted text -

- Show quoted text -

I have tried randbetween. the problem is like you said i sometimes get
the same number twice. What i was looking for is different. I wanted
to know if there was a way for me to get a random list of numbers
between 1 and 10 like this

2
4
3
1
6
10
9
7
5
8

So is there a way to do that or not? maybe with code? I don't know

Thanks
 
G

Glenn

pat67 said:
I have tried randbetween. the problem is like you said i sometimes get
the same number twice. What i was looking for is different. I wanted
to know if there was a way for me to get a random list of numbers
between 1 and 10 like this

2
4
3
1
6
10
9
7
5
8

So is there a way to do that or not? maybe with code? I don't know

Thanks


Go back and read Tom's post again. Try it EXACTLY like he wrote it.
 
S

Steve Dunn

If you're dead set against trying Hutch's solution, you could use a bit of
circular referencing to achieve this. First you will need to turn on
"Enable iterative calculation" from options - read up a bit on this so that
you understand all the implications.

Then in A1:

=RANDBETWEEN(1,10)

in A2:

=IF(($A2=0)+COUNTIF($A$1:$A1,$A2),RANDBETWEEN(1,10),$A2)

copied down A3:A10.

Hold Shift+F9 to generate a new sequence (this re-calculates the sheet). Be
aware that this will generate a new sequence whenever the sheet is
re-calculated, unless you fix the number in A1.




Pat,

If you used RANDBETWEEN(1,10) you would be likely to get repeated numbers
in
your range. You asked for the numbers 1 through 10 to be sorted in a
random
order, which is exactly what Hutch's solution does - RAND() is only used
for
sorting the numbers, not producing them.






Rand() only generates between 0 and 1- Hide quoted text -

- Show quoted text -

I have tried randbetween. the problem is like you said i sometimes get
the same number twice. What i was looking for is different. I wanted
to know if there was a way for me to get a random list of numbers
between 1 and 10 like this

2
4
3
1
6
10
9
7
5
8

So is there a way to do that or not? maybe with code? I don't know

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top