Open the Data Validation table by following the steps provided in the above fix. Under the Settings tab, click on the Clear All button. Click OK to save the changes.

We’ll use data validation to prevent duplicate numbers in the Membership Number column. First, enter the following function into cell K3: =COUNTIF(Table1[Membership Number],B3) ...