Solved

# Determining placement of text based on a number or percentage

Posted on 2011-03-21

Ok.. The title is horrible but I couldn't figure out how to phrase what I'm looking for.

Let me explain what I'm trying to do.

I'm trying to put together a spreadsheet for a baseball season ticket draft that I have coming up. Currently we have 5 people though this could change in the draft. There are 83 games, this could fluctuate up and down also. I need a way to determine where to put people in the drat order.

Still confused? I am. Here is what I'm currently doing by hand.

83 Games

Josh - 30 games - One pick every 2.7 turns

Jim - 20 Games - 4.15

Mike - 18 Games - 4.61

Bill - 10 Games - 8.3

Frank - 5 Games - 16.6

What I would like to do is have a list of people in the league in a column and the number of games in the next.

A C

Josh 30

Jim 20

Mike 18

Bill 10

Frank 5

I would like the spreadsheet to go down and place the people where they should pick. One Caveat, Mike ALWAYS picks first.

1. Mike

2. Josh

3. Jim

etc.

Does that make sense at all? Am I trying to do too much?

Thanks

Josh