Hi there
I've had a look through the board to find the answer to this but if I've missed it I apologise.
We've taken ticket requests for a show where each person can request up to 6 tickets. Each person's details appears in one Excel row.
We have 100 tickets to give away, how do I get a random selection where the total number of requests=100.
I can do it using sampling if every row equates to the same number of requests but in this case it doesn't, can anyone help???????????
I've had a look through the board to find the answer to this but if I've missed it I apologise.
We've taken ticket requests for a show where each person can request up to 6 tickets. Each person's details appears in one Excel row.
We have 100 tickets to give away, how do I get a random selection where the total number of requests=100.
I can do it using sampling if every row equates to the same number of requests but in this case it doesn't, can anyone help???????????