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!
Bookmarks