Prevent Duplicate Entries in Excel (2 Simple Ways)

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 - trumpexcel.com/prevent-duplic...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@npc2856]

Great video! How could I change the formula to only check a certain range? Perhaps C10:H50 for example? I tend to have "names" scattered along a block of rows and columns and have duplicates, so I would like to prevent duplicates using your first method if possible. Thanks.

[@trumpexcel]

@@npc2856 You need to first select the range (say C10:H50 in this example), and then use the same formula. So for C10:H50, you can use the formula =COUNTIF(C10:H50,C10)=1

[@kaushaldalal587]

thank you Sumit. Its very useful. Really appreciate your knowledge and efforts to share with us.

[@trumpexcel]

Thanks Kaushal... Glad you found the video useful 🙂

[@neccomputercenter458]

"Super se Upper"!! Thank You Sir👌

[@IvanCortinas_ES]

Excellent Sumit! Thank you for sharing!!!

[@sakisl7739]

Simple and helpful! Thank you!

[@trumpexcel]

Glad you found the video useful 🙂

[@unique-wolf495]

I have watched your excel course twice on the google website. Thanks for sharing with us ❤️🌹

[@PrincesDiana8966]

Thank you brother for your lovely video 👍

[@pancux670]

Awesome informative as always. Thanks

[@frenan82]

great! good formula in data validation... thanks

[@trumpexcel]

Thanks for commenting... Glad you found the video useful :)

[@relax_eglence]

Lots of thanks from Turkmenistan🤝

[@cihanserdar8627]

You are the king 👑👑

[@Satwant2463]

Thank you👍🏼

[@anasahmad5415]

Hi Sumit can you please bring a course DAX ? you are best

[@nazarkamal8831]

Thanks 🙏🙏🙏🙏🙏👍👍👍

[@trumpexcel]

Glad you found the video useful 🙂

[@user-yk1wm3ke8b]

I loved it, but how to remove duplicate

[@ameeraliadcoopsabudhabi8923]

Thanks lot ,But while i copy to past error not showing.

[@hakimali1497]

If collum B date and collum C is employee Id so what i do not allow double entry employee id same date

[@tanushreerouth1891]

Can I use the same technics in the google sheets?

[@trumpexcel]

Yes, this can also be done in Google Sheets

[@user-os8yo7rz4g]

I WANT TO PREVENT DUPLICATION IN COLUMN "C", WILL THE FORMULA APPLY SAME?