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.

Validation is a powerful feature that lets you control the data users can enter into an Excel sheet. Chances are that once you’ve put these rules into place, you’ll not want to remove it, but ...