G
Garry Hope
Hi,
I've ran a competition and need to "pick the winners out of a hat". I
it was one entry per name then I would have used a RANDBETWEEN to selec
my 10 random numbers and that would be that, however there are multipl
entries per person.
The only problem though is that the number of entries each person has i
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 amoun
of entries into consideration.
I wanted to copy and paste each name the required amount of times bu
that's obviously very time consuming as there are 361 entrants with ove
7,000 entries between them.
Does anyone have a possible solution to this or know of any VBA codin
that may help me with this?
Perhaps something that will auto copy and paste each name x amount o
times then group them all into 1 column?
Thanks in advance
Garr
I've ran a competition and need to "pick the winners out of a hat". I
it was one entry per name then I would have used a RANDBETWEEN to selec
my 10 random numbers and that would be that, however there are multipl
entries per person.
The only problem though is that the number of entries each person has i
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 amoun
of entries into consideration.
I wanted to copy and paste each name the required amount of times bu
that's obviously very time consuming as there are 361 entrants with ove
7,000 entries between them.
Does anyone have a possible solution to this or know of any VBA codin
that may help me with this?
Perhaps something that will auto copy and paste each name x amount o
times then group them all into 1 column?
Thanks in advance
Garr