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