Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Random Number Non Repeating ...
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to keep random number from changing using RANDBETWEEN? | Excel Worksheet Functions | |||
Repeating number sequence in a column | Excel Discussion (Misc queries) | |||
VB Random Number Generation/Insertion/NextWorksheet | Excel Discussion (Misc queries) | |||
Random Number Questions | Excel Worksheet Functions |