Duplicate Checking of Multiple Dropdown Values with criteria


Hello guys! I have these conference registrations at which multiple attendees can have different conference badge. The badge column allows multiple entries. My goal is to identify if an attendee has selected the same badge in multiple registration:

E.g. Attendee Marcus Schabacker has entered 2 registrations, both registrations have "ANS" and "PUB" badges. How do I get to flag this type of duplicate?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!