mercredi 12 août 2020

Change Column value from 1 to 0

I have a column with 1 and 0 that I would like to change to the opposite.

|This   |Should be|
| 0     |1        |
| 1     |0        |
| 0     |1        |
| 1     |0        |
| 0     |1        |

I tried to do =ARRAYFORMULA(SUBSTITUTE(A2:A,"0","1","")) But this changes all the values to 0, same thing if I do the Replace function :(

Any suggestions?

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire