Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
In B2:
=B1+(IF(A2=0,-1,1)) Fill down -- Kind Regards, Niek Otten Microsoft MVP - Excel "OldKenGoat" wrote in message ... 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 |
#3
|
|||
|
|||
B1: =A1
B2: =B1+(IF(A2=0,-1,1)) and copy B2 down -- HTH RP (remove nothere from the email address if mailing direct) "OldKenGoat" wrote in message ... 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 |
#4
|
|||
|
|||
Thanks, Niek. It worked perfectly!!!
Niek Otten wrote: In B2: =B1+(IF(A2=0,-1,1)) Fill down "OldKenGoat" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If column A and column B have values how do i get the total in co. | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
PivotTable Column Field Values | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel |