CODEWITHSUNDEEP
vbaexcelrandom
mriley
mriley

Reputation: 1

Excel randomly select name from list with multiple entries

I have an excel 2007 worksheet with employee names in column A and total number of entries in column B. I need to be able to randomly select x number of employee names from the total number of entries, allowing for the fact that some will have multiple entries.

For example:

Amy............30   
Brian..........12
Charlene.......15
Michael.........1
Nathan..........7

What is the best way to do this?

My initial thoughts are:

1) find the max() of column B occurances of a random number in another column, like C. Then find the top values for all of that new column.

2) create a VBA array of all of the potiential entries and randomly pick one from there.

3) loop through all of the names in column A and create a temp worksheet with column B instances of each, then assign a random num generator and choose the top n.

Having said that, there may be something a lot easier. I am not sure where to begin. Normally I can find code that is similar to what I need, but I am not having any luck. Any help that you can offer would be appreciated.

Thank you in advance.

Upvotes: 0

Views: 6670

Answers (1)

Stepan1010
Stepan1010

Reputation: 3136

I would probably do something like this if I understand your question correctly(I just read your question title):

SO1

SO2

Upvotes: 2

Related Questions