Random Numbers In Excel, Without Duplicates, Based On Weighted Value
May 8, 2014 12:43 PM Subscribe
I need a way to generate a random set of numbers in excel, with some numbers having a more likely chance to be selected based on a weighted value associated with that number. But without the number being duplicated.
posted by ndillon to Computers & Internet (10 answers total) 4 users marked this as a favorite
I am trying to create a random list of 5 questions from a list of 25 questions. Some of these questions are more important than others, and therefore need to be generated more often than others. I would like to tie a weighted score to those more important questions which would in turn increase the possibility that it would be generated more often than others.
I would then like to create an additional 5 questions, but I do not want them to be a repeat of any that were generated the first time.