re-sorting numbers randomly in a column

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I am looking for advice on how to randomly resort a assigned set of
numbers within a preset column. For example, if I had the following
numbers (2,6,7,3,2,1,1,) lined up in a column, how could I take those same
numbers and rearrange them in the same column?
 
Robert

The easiest way is with a helper column. In the column alongside the numbers
you have, type
=RAND()
and fill down. You can then sort on this column to randomise the list. The
RAND() function will change the list on every recalculation of Excel.

Andy.

I am looking for advice on how to randomly resort a assigned set of
numbers within a preset column. For example, if I had the following
numbers (2,6,7,3,2,1,1,) lined up in a column, how could I take those same
numbers and rearrange them in the same column?
 
Back
Top