call us today: 1.800.876.8376
email us: info@synergy.com
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)


Mark as helpful.
0

Posted in: Formula Entry: Advanced formulas