MOD is more versatile thank you might think.

How to use Excel formulas to compare multi-column lists Your email has been sent Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none of ...