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
Synergy Software
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.