Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I randomly sort data in a column?
I'm working in a Stat class and I need to sort data randomly. I've arranged
the data in a column and would like to select the data and sort randomly. I thought I could do this in previous versions fairly easily, but it seems that option is not easy in 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I randomly sort data in a column?
goody, you could use a helper column put =RAND() in a column next to your
data, fill down to the end of your data and then sort on that column -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "goody" wrote in message ... I'm working in a Stat class and I need to sort data randomly. I've arranged the data in a column and would like to select the data and sort randomly. I thought I could do this in previous versions fairly easily, but it seems that option is not easy in 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with referencing please | New Users to Excel | |||
Sort by column problems | Excel Worksheet Functions | |||
Stock data manipulation | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |