The function wizard for the RndPermutation function looks as follows:
RndPermutation(Value)
Value. Dimension of the required array, greatest value in it. Parameter value cannot be less than one.
NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.
Returns an array that is an arbitrary permutation of another array, which elements are integers ranging from 1 to the value of the passed parameter.
| Formula | Result | Description |
| = RndPermutation(A1) | Changes. | A random number between one and the value stored in the A1 cell. |
| = RndPermutation(5) | Changes. | A random value between 1 and 5. |
See also: