Hi,

I've ran a competition and need to "pick the winners out of a hat". If it was one entry per name then I would have used a RANDBETWEEN to select my 10 random numbers and that would be that, however there are multiple entries per person.

The only problem though is that the number of entries each person has is summed up with the adjacent column.

For example;

Column A contains number of entries (summed up) (number x)
Column B contains the persons name

A, B,
1012, Josh,
134, Greg,
874, Tom,

and so on....

What I need to do then is pick 10 random winners but taking the amount of entries into consideration.

I wanted to copy and paste each name the required amount of times but that's obviously very time consuming as there are 361 entrants with over 7,000 entries between them.


Does anyone have a possible solution to this or know of any VBA coding that may help me with this?

Perhaps something that will auto copy and paste each name x amount of times then group them all into 1 column?

Thanks in advance :)

Garry