pat67 wrote:
On May 5, 4:24 pm, "Steve Dunn" wrote:
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" wrote in message

...
On May 3, 5:23 pm, Tom Hutchins





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


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