There’s no built-in duplicate rule for Excel’s Data Validation feature, ... If you’re working with your own data, be sure to update the name of the Table and column. Click OK.