| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randomly Re-arrange Entries in an array.
Hi,
I have a 203x203 array of non-negative numbers which I want to re-arrange at random in another sheet. I've tried creating and using an array of random numbers in another sheet to reorder the data but it isn't quite working out. Does anybody know of a formula I can use to accomplish this? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| randomly select a cell from an array | Excel Discussion (Misc queries) | |||
| Can I randomly select values from an array with removal? | Excel Discussion (Misc queries) | |||
| Array formula for unique entries | Excel Worksheet Functions | |||
| Can Excel randomly pick one winner out of 100 contest entries? | Excel Discussion (Misc queries) | |||
| How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) | |||
Threaded Mode
