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
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.
@@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
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
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.
@@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
Very helpful.. thank you..❤
Simple and helpful!
Thank you!
Glad you found the video useful 🙂
thank you Sumit. Its very useful. Really appreciate your knowledge and efforts to share with us.
Thanks Kaushal... Glad you found the video useful 🙂
"Super se Upper"!! Thank You Sir👌
great! good formula in data validation... thanks
Thanks for commenting... Glad you found the video useful :)
Excellent Sumit! Thank you for sharing!!!
Lots of thanks from Turkmenistan🤝
I have watched your excel course twice on the google website. Thanks for sharing with us ❤️🌹
You are the king 👑👑
Thank you brother for your lovely video 👍
Thanks 🙏🙏🙏🙏🙏👍👍👍
Glad you found the video useful 🙂
Awesome informative as always. Thanks
Thank you👍🏼
I loved it, but how to remove duplicate
❤
Hi Sumit can you please bring a course DAX ? you are best
Can I use the same technics in the google sheets?
Yes, this can also be done in Google Sheets
If collum B date and collum C is employee Id so what i do not allow double entry employee id same date
Thanks lot ,But while i copy to past error not showing.
I WANT TO PREVENT DUPLICATION IN COLUMN "C", WILL THE FORMULA APPLY SAME?