This worked great. Thank you.

"Bob Umlas" wrote:

Enter the numbers 1-55 in a column, and in an adjacent collumn enter =RAND()
and fill down. Now sort both columns by the RAND column and you'll have the
1-55 shuffled.
Bob Umlas
Excel MVP

"a_ryan1972" wrote in message
...
I have the numbers 1 - 55 that I would like to display in a column
randomly
without repeating. The numbers should be whole numbers only. Can you
help
me? I tried following some of the other posts, but I couldn't get it.

Thanks.