Duplicate Checking of Multiple Dropdown Values with criteria

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!