Number set in random order

[Alex Beaton]

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!

[mdbct]

Please see attached.

In the E column I created randomly generated numbers using "=rand()" then in the A column in rows 2 through 37 I used the formula

Please Login or Register  to view this content.

to get the list of numbers.

[Alex Beaton]

Clever!
thank you