It is currently Sun Dec 21, 2014 7:50 pm

All times are UTC - 8 hours [ DST ]

Post new topic Reply to topic  [ 2 posts ] 
  Print view Previous topic | Next topic 
Author Message
 Post subject: Excel Help
PostPosted: Fri Feb 07, 2014 8:47 am 
Offline
Sponsor
Sponsor
User avatar

Joined: Tue Sep 14, 2010 5:54 am
Posts: 47
I REALLY need to take a class in Excel or something. I'm trying to make a spreadsheet where I can import my league's draft results and then break it down so I can see how many players at each position were drafted in each round. Just a reference for how guys in my league typically draft.

So, I've got my spread sheet with Round in 1 column, position in another. Then I've got another little table with the positions listed out, C, 1B, etc, down a coulmn and the rows across the top identify the round. I've been fussing all morning trying to make an IF statement, but no luck so far. Anyone have any clue how I can do this? I've tried having Excel look at the draft data and see if the round is 1 in the RND coulmn, then look in the position column and if that column=3B, then report a 1, and then tried to sum that. I don't know, I'm an Excel hack, so I'm sure I'm missing something here. Thanks to anyone that can lend me a hand!


Top
 Profile  
 
 Post subject: Re: Excel Help
PostPosted: Fri Feb 07, 2014 10:15 am 
Offline
User avatar

Joined: Tue Jun 03, 2008 5:51 pm
Posts: 32118
This is out of my expertise, sorry

_________________
Grey Albright
http://razzball.com
Image

If you want me to look at your team, post the team. Don't post a link to another site where the team is.
Have you given me all the info I need to judge your team? The number of teams in the league is a good start for the big overall questions.
Is your league H2H? Roto?
I don't know who's on your waivers. Don't just ask me who you should pick up. Give me names to choose from.
If you only have one team, post your team in your signature with the league parameters.
I don't know every single matchup for next week, so if you want me to choose a player for the following week and you think the matchups are important, tell me who they're facing.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: