Woof 0 Posted July 25, 2003 Got an Excel Question. My league has a little different set of rules. If I picked Clinton Portis in the 7th round last year I get him in the 5th this year if I so desire. Each team can do this to a MAX of 2 players. So, similar to a keeper league. My question is this. I know before the draft where these keepers will be picked. ie. Portis in the 5th. When I enter Portis in the 5th round (before the draft begins) he does come off the master sheet and all the other sheets. The only problem is that he doesn't show up in the BY ROUND "TAB" until after that pick. Is there any way to have him show up in the "BY Round" Tab before the draft begins. It would help me plan some picks... Hope I explained it well enough. Thanks. Share this post Link to post Share on other sites
Woof 0 Posted July 25, 2003 Sorry, I think I figured it out. Share this post Link to post Share on other sites
chtrich 0 Posted July 25, 2003 ooh, really, what did you do? I would use the same feature and just assumed it was a limitation. ???? Thanks, Chris Share this post Link to post Share on other sites
Woof 0 Posted July 25, 2003 I went into the formula on the "by round" tab and deleted the second section after the IF (E9>AB,............, It seemed to have worked. I'm just checking now and seeing if it affected any of the other sheets. That's what I was most concerned about. Share this post Link to post Share on other sites
chtrich 0 Posted July 25, 2003 Yes, I saw that, but how did you figure it out is the question? Share this post Link to post Share on other sites
chtrich 0 Posted July 25, 2003 so did it mess anything else up or does the rest of the draft results still work fine? Share this post Link to post Share on other sites
Mike MacGregor 20 Posted July 25, 2003 You guys are scaring me It should not effect any other sheet in Draft Buddy as nothing else is dependent on any results from the by round tab. I have to think there was a reason I have that part of the formula in there though, but damn if I can figure it out right now. Share this post Link to post Share on other sites
chtrich 0 Posted July 25, 2003 Well if you think of it let me know. I want to make sure it's safe before I delete it. Of course if it is safe you might want to take it our for future updates for all of us that use keepers. Share this post Link to post Share on other sites