How do I generate random numbers in MS-Excel without repetition??

Question

I want to use the "randbetween" function to generate random numbers between 1 and 100 in MS-Excel. How do I do this wihout repetiton of any number?

Thanks for your help!!

Answer 1

Using randbetween function, generate more than 100 sets, the more the better.
Copy and pastespecial as values.

Using autofilter, extract it as unique. You should have exactly unique set.

Answer 2

Surely if you try to prevent repetition, then the
generation isn't going to be random. Is it? In which
case the RANDBETWEEN function is not going to
be the best choice...

Off the top of my head, I'd say it would be far easier
to pick the numbers at random from a Range, Set,
or Array, which gets reduced in size each time by
removing the number picked.

HTH ( a little.. ).