Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Sequence with no Duplication
Suppose I start with a list of 100 numbers in sequence, let’s just say 1 to 100 where the number 1 is in cell A1, 2 is in cell A2, 3 is in cell A3 through to the number 100 in cell A100. In column B: 1) I would like to be able to have these numbers listed in random order, with no number appearing more than once and 2) Have the capability to be able to change this random sequence at any time by performing some simple action. Is there any way this can be done in Excel? I am using Excel 2000. Thanks -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=474812 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Sequence with no Duplication
Yes. In cell B1 put =RAND() and copy down the column.
Sort by column B and the numbers in column A will re-arranged randomly. To repeat this process, just touch F9 and repeat the sort. -- Gary's Student "nebb" wrote: Suppose I start with a list of 100 numbers in sequence, lets just say 1 to 100 where the number 1 is in cell A1, 2 is in cell A2, 3 is in cell A3 through to the number 100 in cell A100. In column B: 1) I would like to be able to have these numbers listed in random order, with no number appearing more than once and 2) Have the capability to be able to change this random sequence at any time by performing some simple action. Is there any way this can be done in Excel? I am using Excel 2000. Thanks -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=474812 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Sequence with no Duplication
Take a look he
http://mcgimpsey.com/excel/udfs/randint.html In article , nebb wrote: Suppose I start with a list of 100 numbers in sequence, let’s just say 1 to 100 where the number 1 is in cell A1, 2 is in cell A2, 3 is in cell A3 through to the number 100 in cell A100. In column B: 1) I would like to be able to have these numbers listed in random order, with no number appearing more than once and 2) Have the capability to be able to change this random sequence at any time by performing some simple action. Is there any way this can be done in Excel? I am using Excel 2000. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate random sequence based on probability | Excel Discussion (Misc queries) | |||
Random duplication in excel shared workbook.....Help! | Excel Discussion (Misc queries) | |||
Random Sample Without Duplication | Excel Discussion (Misc queries) | |||
I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS | Excel Worksheet Functions | |||
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) |