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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>
FWIW, another way, which will change whenever the sheet is calculated.
Cell A1. Enter the =RAND() function and copy down to A55.
Cell B1. Enter the formula =RANK(A1,A$1:A$7), and copy down to B7.
Hit F9 to recalculate...every time worksheet calculates a new random
ordering.
Roger
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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks