how to avoid duplicate entries in excel using data validation

Описание: You can avoid or prevent duplicate entries in Excel automatically by using a combination of data validation, absolute cell references and the countif function. We have discussed data validation, cell references and the countif function in the earlier videos in detail. The process is very useful when you have to enter many item IDs or numbers.