| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random sorting of list
Is it possible to sort a list automatically in a random order??
Kathrine |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random sorting of list
If your list is in column A, in column B enter:
=RAND() and copy down as far as the list in column A. Then sort both columns by column B. -- Gary''s Student gsnu200712 "Kathrine" wrote: Is it possible to sort a list automatically in a random order?? Kathrine |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random sorting of list
"Kathrine" wrote:
Is it possible to sort a list automatically in a random order?? One play .. Assuming the items are listed in A1:A5 In B1: =RAND() In C1: =INDEX($A$1:$A$5,RANK(B1,$B$1:$B$5)) Select B1:C1, copy down to C5. Hide away col B. Col C returns a random scramble of the items in A1:A5 Just press F9 to regenerate. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick a Random name from a list. | Excel Discussion (Misc queries) | |||
| extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
| Random items from a list? | Excel Discussion (Misc queries) | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
