RndPermutation

Syntax

RndPermutation(Value)

Parameters

Value. Dimension of the required array, the 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.

Description

It 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.

Example

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.