Chandoo,
So close...but a few questions. First off, when I paste in your formulas as is I get a "too few arguments" for the formula that goes in C1...so I don't completely understand the formula but I put this in it's place "=IF(ROWS($B$1:B1)<=$A$1*$A$2,MOD(ROWS($B$1:B1),$A$2),"")"...
I am in need of a way to dynamically build a table based on the a few parameters that I enter in my worksheet. For example, say that I have a cell that allows me to enter the number of names per team and another cell that asks how many teams...so I put in [5] names per team and [3] teams. I...