Prevent Duplicate Entries in Excel (2 Simple Ways)
Рет қаралды 9,864
Күн бұрын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: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial
@trumpexcel 5 ай бұрын
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 5 ай бұрын
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 5 ай бұрын
@@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 5 ай бұрын
thank you Sumit. Its very useful. Really appreciate your knowledge and efforts to share with us.
@trumpexcel 5 ай бұрын
Thanks Kaushal... Glad you found the video useful 🙂
@IvanCortinas_ES 5 ай бұрын
Excellent Sumit! Thank you for sharing!!!
@sakisl7739 5 ай бұрын
Simple and helpful! Thank you!
@trumpexcel 5 ай бұрын
Glad you found the video useful 🙂
@pancux670 5 ай бұрын
Awesome informative as always. Thanks
@frenan82 5 ай бұрын
great! good formula in data validation... thanks
@trumpexcel 5 ай бұрын
Thanks for commenting... Glad you found the video useful :)
@neccomputercenter458 5 ай бұрын
"Super se Upper"!! Thank You Sir👌
@PrincesDiana8966 5 ай бұрын
Thank you brother for your lovely video 👍
@unique-wolf495 5 ай бұрын
I have watched your excel course twice on the google website. Thanks for sharing with us ❤️🌹
@Satwant2463 5 ай бұрын
Thank you👍🏼
@nazarkamal8831 5 ай бұрын
Thanks 🙏🙏🙏🙏🙏👍👍👍
@trumpexcel 5 ай бұрын
Glad you found the video useful 🙂
@cihanserdar8627 5 ай бұрын
You are the king 👑👑
@relax_eglence 5 ай бұрын
Lots of thanks from Turkmenistan🤝
@anasahmad5415 5 ай бұрын
Hi Sumit can you please bring a course DAX ? you are best
@user-yk1wm3ke8b 5 ай бұрын
I loved it, but how to remove duplicate
@hakimali1497 Ай бұрын
If collum B date and collum C is employee Id so what i do not allow double entry employee id same date
@ameeraliadcoopsabudhabi8923 3 ай бұрын
Thanks lot ,But while i copy to past error not showing.
@tanushreerouth1891 5 ай бұрын
Can I use the same technics in the google sheets?
@trumpexcel 5 ай бұрын
Yes, this can also be done in Google Sheets
@user-os8yo7rz4g 2 ай бұрын
I WANT TO PREVENT DUPLICATION IN COLUMN "C", WILL THE FORMULA APPLY SAME?