79363889

Date: 2025-01-17 07:09:27
Score: 1.5
Natty:
Report link

This formula outputs the randomized data from a single-column input range.

=CHOOSECOLS(SORT(HSTACK(DataArray, RANDARRAY(ROWS(DataArray),1)),2,TRUE),1)

From inside out...

  1. RANDARRAY creates a 1-column array of random numbers with the same size as the input data.
  2. HSTACK creates a 2-column array with the DataArray as column 1 and the random number array as column 2.
  3. SORT sorts the 2-column array by the random numbers.
  4. CHOOSECOLS outputs the first column.
Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: pumpkinslayer