SHUFFLE

Randomly shuffles the values in the given array.

Syntax

=SHUFFLE(array)

Arguments

ArgumentTypeDescription
arrayArrayThe array of values to shuffle

Examples

=SHUFFLE([1, 2, 3, 4, 5])[4, 5, 2, 1, 3]