How to generate random non-repeating values?

Question

excel

In 40 cells it is necessary to generate 40 values ​​randomly (for example: = RANDBETWEEN (1; 40)) but in such a way that the values ​​do not repeat.

Answer 1

generate from 1 to 40 in order, then: https://www.google.com/search?q=excel+shuffle