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