If you are doing data entry in Excel and wondering how to stop Excel from allowing you to enter duplicate entries, this video will give you the answer.

In this video, I will show you two simple methods to prevent duplicate entries in Excel.

00:00 Intro
00:16 Prevent Duplicate Entries Using Data Validation
04:38 Prevent Duplicate Entries Using Conditional Formatting

While the Data Validation method would stop you from entering duplicate values in a column, the Conditional Formatting method would visually highlight and show you whenever you enter a value that is already present in the column.

Read the article - https://trumpexcel.com/prevent-duplic...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

#Excel #ExcelTips #ExcelTutorial