How to Restrict duplicate data entry in a column in Excel

preview_player
Показать описание
How to Restrict duplicate data entry in a column in Excel. Using the Data Validation Custom formula feature, you can enter a Countifs formula and not allow duplicate data entry by user. Once you disallow duplicate entry, cleanliness of data is automatically done.

SUBSCRIBE NOW!

Click this link to learn more awesome functions in Excel

Click this link to learn how to manage your personal finance using Excel
Рекомендации по теме
Комментарии
Автор

Amazing! This helps my team solve major RSVP issues!

avinaashbodwaani
Автор

Respected Sir, above formula has run successfully, thanks, but problem arise when I copy some numerical data from Ms word to this Excel sheet, the formula does not working, sir please give some solutions kindly. Regards

sumantaghosh
Автор

i have restricted duplicate entry in column A in data validation with
=COUNTIF($A$2:A99, A1)=1 but along with this i want to
restrict charactor entry to Max 30 Charactor how to do ? if more then 30
charactor is entered it should give error message

deepakbhanushali
welcome to shbcf.ru