C
C
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
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