Counting to a specified numberin round, then add one to round

Hi everyone

First, let me say that I am a novice user of Excel. I have attached a workbook that contains a hockey offline draft. It is done (although not the most efficient way) to suit a 12 team league. My problem is on the "Fantasy Rankings" page you can select an "Owner" and the round is supposed to say "1" for round one. Once the 12th owner has made his selection, the round in the adjacent cell should say "2", while the previous 12 selections stay at "1". Right now they all change to 2. This, of course, continues as you select more players.

My question is, how do I keep the first 12 players selected to have a "1" in the "round" column, the next 12 to have a "2" in the round column, an so on, up to 20 in the "round" column.

That is it!!! Thank you so much!

It appears that there is a little flaw with the formula. If Players are selected from Crosby (1) to Perry (11) everything works fine. But the problem arises when the 12th owner makes a selection of say, Spezza (31). This will say round 1, which is correct. But then for his next selection (the first pick of round 2) he decides to take Nash (20). The formula makes Nash round one and Spezza 2. Any further help is greatly appreciated. Thanks

I tried the code but could not get it to work (again, a novice user). I'm not exactly sure what I was supposed to do. I attached the latest copy of the file I have with your code inserted. If, when I select Jason Spezza (31) for "Manager #12" it is correct in saying the round is 1. But, "Manager #12" gets the immediate next pick. He decides to choose Ryan Getzlaf (19). It still makes Getzlaf round 1 and Spezza round 2. Am I supposed to erase the formula in column F or is the code not running (I've never used code in Excel before). Thanks again. I really appreciate all this help. You guys are great!

Still nothing. Is the formula in F1 stopping this? When I open the workbook do I have to run anything to initiate the code? I still need a "1" or whatever in column F to show so the formula in F1 works

I'm so close to saying this is done.

I am getting something in the "E" column. Unfortunately it's a "0" and it does not go to "1" when the next round has started after I have selected the 13th person. I very much appreciate you help and patience on this topic.

Where's the facepalm emoticon? haha. You sir, are a genius! It works! I am eternally grateful. Now I need to try and understand how the code actually works. Again, many thank yous.