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