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

01/21/2023

Japanese version.

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

Contents

Formula

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

Please make changes where indicated in red.

=CHOOSECOLS(SORT(HSTACK(TargerCellRange,RANDARRAY(LEN(TargerCellRange),1)),2),1)

This reordering is done each time the formula is recalculated.

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

=CHOOSEROWS(SORT(VSTACK(TargerCellRange,RANDARRAY(1,LEN(TargerCellRange)),2,1,TRUE),1)

---