View Single Post
  #1   Report Post  
OldKenGoat
 
Posts: n/a
Default How do I increment or decrement values in a column?

I have a column of the numbers 1 and 0. In an adjacent column, I want to
increment or decrement the value by 1. I know there's a simple way to do
this, but, I can't see it! Thanks for any help, OldKenGoat
Example:
Col A Col B
0 0
1 1
1 2
1 3
0 2
1 3
1 4
0 3
0 2
0 1
0 0
1 1
1 2
0 1