However, if you do this, The Data Validation feature will not work. Excel will not show you a warning message if the data you enter mismatches the data entered in the Data Validation table.

By adding the COUNTIF() function to the data validation settings, you can use this feature to reject a value if it already exists within range. Before you start, make sure the column in question ...