Solved

# Determining the order of a list based on a number

Posted on 2012-03-20

Hopefully my explanation is better than the Title. I apologize for it's lack of clarity.

Here is what I'm trying to do.

Every year where do a baseball ticket draft. Whereas we split up the number of tickets, in this case 81, and each person gets a chance to pick a game that they like.

The problem here is that everyone does not get the same number of tickets so just doing a simple repeating list won't work.

What I would like to figure out how to do is input each persons name and the amount of tickets they have and then just have the excel spreadsheet go ahead and assign the slots properly.

The only caveat is that each person gets a pick in the first round.

Here is my list of people and their ticket #'s

Mike 21

Josh 16

Drew 15

Bill 10

Matt 9

Todd 8

The first round would be in the order above.

The second and following rounds would need to be split up. i.e. mike would get a pick roughly every 4 picks whereas Matt would only get a pick every 9 picks.

Does that make sense?

Is this doable? I don't even know where to start.

Thanks

Josh