I want to arrange a set of integers in a random order without repeats.
For example, arrange the numbers 1,2,3.........36 in random order*.

The function RANDBETWEEN() could be used but has to be prevented from using numbers more than once. A logic statement would do this but I can't work out how to do it.

Can anyone help, please?

* Obviously, the last number cannot be randomly selected!