random number generator
in [Functions]
|
Prev: Excel Formulas not duplicating to the next Cell, copying the valueinstead.
Next: Aggregating data among multiple workbooks
From: pat67 on 3 May 2010 16:27 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 3 May 2010 17:23 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 3 May 2010 17:45 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 5 May 2010 12:03 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 5 May 2010 16:24
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 |