| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
The opposite of the "sort" function
I have a list of alphabetically ordered data in a column.
Is there a function for randomizing the order of these data? |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
The opposite of the "sort" function
|
|
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
The opposite of the "sort" function
Exellent solution! thanks!
|
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
|
The opposite of the "sort" function
Let's say your data in A1:A10
In B1: =RAND() copy from B1 to B10 Select A1:B10 Data Sort Sort by select Column B select Ascending OK " wrote: I have a list of alphabetically ordered data in a column. Is there a function for randomizing the order of these data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Linear Mode
