From: pat67 on
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?
From: Tom Hutchins on
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

"pat67" wrote:

> 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?
> .
>
From: Simon Lloyd on

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


p
a
t
6
7
;
7
1
5
1
9
2

W
r
o
t
e
:


>
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?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=200205

http://www.thecodecage.com/forumz

From: pat67 on
On May 3, 5:23 pm, Tom Hutchins
<TomHutch...(a)discussions.microsoft.com> wrote:
> 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
>
>
>
> "pat67" wrote:
> > 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?
> > .- Hide quoted text -
>
> - Show quoted text -


Rand() only generates between 0 and 1
From: Steve Dunn on
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.



"pat67" <pbuscio(a)comcast.net> wrote in message
news:b0967ea1-a1de-4239-95d7-a28098067dbc(a)u7g2000vbq.googlegroups.com...
On May 3, 5:23 pm, Tom Hutchins
<TomHutch...(a)discussions.microsoft.com> wrote:
> 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
>
>
>
> "pat67" wrote:
> > 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?
> > .- Hide quoted text -
>
> - Show quoted text -


Rand() only generates between 0 and 1