Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
JiveSly
Lv 4
JiveSly asked in Computers & InternetOther - Computers · 1 decade ago

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

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

2 Answers

Relevance
  • unnga
    Lv 6
    1 decade ago
    Favorite Answer

    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.

  • Anonymous
    1 decade ago

    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.. ).

Still have questions? Get your answers by asking now.