S
Storm_21_924
Hi Excel Formula Guru's.
Here's a complicated one I'm thinking about. I haven't started it
yet, more in the planning stages, although I'd like to get it done.
I'm pretty self sufficient when it comes to excel, however this time
I'm getting in over my head I think.
Scenario:
sheet 1 - basically a worksheet of formula, references and Data
Sheet 2-4,5,6(not sure how many pages yet). basic Grid 12 columns 14
rows.
Basically this is going to be used to track fantasy football draft
boards and player rankings.
Roughly, here's what I'm looking to do, over the next couple weeks I
want to hold mock drafts, Track where the certain player is drafted
then formuate an average drafting position..
I figure sheet 1 will have a player list, Somehow as the following
sheets get filled out(draft boards), I think I would need to assign
each cell on the board a number, then reference it so can then average
each player's position.
Then I would like to have a positional chart ranking the highest to
lowest player based on their average draft position.
I'm not quite sure how to start.. Any help would greatly be
appreciated.
Thanks!
Shaun
Here's a complicated one I'm thinking about. I haven't started it
yet, more in the planning stages, although I'd like to get it done.
I'm pretty self sufficient when it comes to excel, however this time
I'm getting in over my head I think.
Scenario:
sheet 1 - basically a worksheet of formula, references and Data
Sheet 2-4,5,6(not sure how many pages yet). basic Grid 12 columns 14
rows.
Basically this is going to be used to track fantasy football draft
boards and player rankings.
Roughly, here's what I'm looking to do, over the next couple weeks I
want to hold mock drafts, Track where the certain player is drafted
then formuate an average drafting position..
I figure sheet 1 will have a player list, Somehow as the following
sheets get filled out(draft boards), I think I would need to assign
each cell on the board a number, then reference it so can then average
each player's position.
Then I would like to have a positional chart ranking the highest to
lowest player based on their average draft position.
I'm not quite sure how to start.. Any help would greatly be
appreciated.
Thanks!
Shaun