I have a spreadsheet that has data in rows A1 through B500. For each row I
would like to add 1 to column b 1 thru 500. However, when column b = 5 then
that row value for b becomes 0 and 1 is added to column a of that row.

A B
1 0
1 1
1 2
1 3
1 4
2 0
2 1

Can someone help?

Thanks in Advance
CB

Do it with two formulas

in A1 =int((Row()-1)/5)+1

in B1 put =mod(Row()-1,5)

Copy formulas down column A and b

"C" wrote:

I have a spreadsheet that has data in rows A1 through B500. For each row I
would like to add 1 to column b 1 thru 500. However, when column b = 5 then
that row value for b becomes 0 and 1 is added to column a of that row.

A B
1 0
1 1
1 2
1 3
1 4
2 0
2 1

Can someone help?

Thanks in Advance
CB