How do I compare two columns to see if any two contain equal values?

The following formula can be used to compare three columns (c1-c3) to see if any two contain equal values. If all three values are different, the data in c0 is masked.

mask((c1 != c2) && (c1 != c3) && (c2 != c3), c0)

Scroll to Top