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),"")" although I don't think that it is right.

So here is what I have in my spreadsheet:

in A1 I have set it to a range called "Teams" and the value is 2

in A2 I have set it to a range called "Players" and the value is 2

in B1 I have the following formula: "=IF(ROWS($B$1:B1)<=Teams*Players,INT(ROWS($B$1:B1)/Players),"")"

in C1 I have the following formula: "=IF(ROWS($B$1:B1)<=Teams*Players,MOD(ROWS($B$1:B1),Players),"")"

Here is the output:

0 1

1 0

1 1

2 0

I was looking for:

1 1

1 2

2 1

2 2

I think that the 0 in the first column is because INT returns the next lower whole integer (1/2=0.5 which goes to 0) and the 0 in the second column is calculated because the mod function has no remainder (2,2)...but maybe not? I have not used those functions before...so maybe I am completely off base here. Anyway, it's close...very close. Any suggestions would greatly be appreciated.

Thank you for your help.

Castetter