Question #15218087

Need help with simulation in excel selecting a weighted random nam from a hat with names appearing more than once?

I'm trying to run a simulation that will select a random name from a list with weights. For example Column A, has 5 names and Column B will have the number of times that name appears in the drawing. Name 1 will appear 20,000 times. Name 2 will appear 20,000 times. Name 3 will appear 10,000 times Name 4 will appear 10,000 times. How do I build a simulation in excel that will randomly draw 1 of the names?

2017-07-30 01:10:40

TELL US , if you have any answer

There is NEVER a problem, ONLY a challange!

The is a free-to-use knowledgebase.
  The was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters


C'mon... follow us!

Made by, history, ect.