Q:

Excel - Swap 0 and 1 over

I have an excel sheet with a column of 1 or 0 values  
I would like to swap the 1 for a 0
and swap the 0 for a 1
for every value in that column only.

A:

If you need to replace the values in the same column, you will need to use either FIND/REPLACE or a VBA macro.
If you want to use a helper column, you can use the formula:
B1: =N(NOT(A1=1))

and fill down.

If you have O365 with dynamic arrays, you can use the formula:
B1: =N(BITXOR(A1:An,1))

and the results will Spill down from row 1 to row n

