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)



© Copyright andrewsexceltips.net All Rights Reserved.