I want to follow up on this solution with the following scenario.
I have a repeating table with a dropdown controls. The dropdown has its data validation set up with the suggested expression.
Validation works just fine when a row is added to the table and a duplicate value is selected in the dropdown. The problem with ...