Formulas to randomly reorder a range of cells.(Microsoft Excel)
Here are some formulas to randomly reorder a range of cells.
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)
---