| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Randomly sort a set group of integers
Hello,
I would like to randomly sort the numbers 1-35 in my worksheet. Each integer is in its own seperate cell, which are currently arranged in descending order in cells A1:A35. I tried selecting A1:A35 and using =UniqRandInt(35) as an array (from http://www.sulprobil.com/html/uniqrandint.html), but every cell returned "#NAME?". Any easy-to-follow help would be appreciated- thanks! -jpeckner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i sort rows randomly? | Excel Discussion (Misc queries) | |||
| How do I randomly sort data in a column? | Excel Discussion (Misc queries) | |||
| How do you randomly sort a RANGE | Excel Worksheet Functions | |||
| A list of Consecutive Integers, can I search for missing integers | Excel Worksheet Functions | |||
| How do I shuffle a group of cells randomly in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
