Randomize List
For rows, enter =RAND() in a column drag down. In another column add this
formula (In this example A1 is the top of the list and the random numbers are in
Column B. Change column letters and range to suit)
=OFFSET($A$1,RANK(B1,$B$1:$B$10)-1,0)
For columns, enter =RAND() in a row and drag right. In another row add this
formula (In this example A1 is the left of the list and the random numbers are
in Row 2. Change row letters and range to suit)
=OFFSET($A$1,0,RANK(B2,$A$2:$L$2)-1)