can i randomly sort a list of names in several cells of a microsoft excel file?

Question

i can sort aphabetically or numerically. i want to sort randomly. need help

Answer 1

http://www.quasar.ualberta.ca/edpy202/tutorial/spreadsheet/ExcelBasics/ExcelBasics.htm

http://www.usd.edu/trio/tut/excel/

Answer 2

yes,,, and the best place to find out how to do it is the HELP FILES in excel thats what they are there for ..... you to use

Answer 3

comparable thought question variety question 17 =INT(RAND()*20) question a million =INT(RAND()*20) question 2 =INT(RAND()*20) question 15 =INT(RAND()*20) question 11 =INT(RAND()*20) question 20 =INT(RAND()*20) question 8 =INT(RAND()*20) question 19 =INT(RAND()*20) question 5 =INT(RAND()*20) question 18 =INT(RAND()*20) question sixteen =INT(RAND()*20) question 3 =INT(RAND()*20) question 9 =INT(RAND()*20) question 7 =INT(RAND()*20) question 13 =INT(RAND()*20) question 14 =INT(RAND()*20) question 10 =INT(RAND()*20) question 4 =INT(RAND()*20) question 12 =INT(RAND()*20) question 6 =INT(RAND()*20) Then the two manually variety or write a macro. The Int function only clears up the messy decimals from using rand via itself Sub Macro1() ' ' Macro1 Macro ' Macro recorded 03/01/2009 via consumer ' ' selection("A1:B21").variety Key1:=selection("B2"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=a million, MatchCase:=fake, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal

Answer 4

Not without a macro, no. I don' do macros, myself though.