Double unary

A unary operation is an operation with only one operand (input).

For example, the screen above shows two groups that contain five values each.

Three values match and two are different.

This works because Excel automatically coerces TRUE/FALSE to 1/0 during math operations.

The first negative changes TRUE values to -1, and FALSE values to 0.

The second negative simply changes -1 to 1.