Formulas to randomly reorder a range of cells.(Microsoft Excel)


Japanese version.

Here are some formulas to randomly reorder a range of cells.



The CHOOSECOLS, SORT, HSTACK, RANDARRAY, and LEN functions are used in the formulas.

Please make changes where indicated in red.


This reordering is done each time the formula is recalculated.

For column direction, use CHOOSEROWS, SORT, VSTACK, RANDARRAY, and LEN.