Prevent Duplicates in a column in Excel

How to prevent Duplicates in a column in Excel with Data Validation!

Hey Data Validation Users, There are N number of stuff you can do with Data Validation based on your creativity. Today I am going to show you how to prevent Duplicates in a column in Excel with the help of Data Validation. Steps to Implement to prevent Duplicates in a column in Excel: Select the Entire […]

Dynamic Drop Down Excel

Dynamic Drop Down List Excel

Hey Excel Dynamic User, I am going to show you one very important technique to create a Dynamic Drop Down List Excelin cells (of course with data validation but with addition to function “INDIRECT”) with n number of dependency you can create. I have tried to make it shortest and easy to understand with 5 […]


How to create drop down in Microsoft Excel?

Hello Excel Lovers, In this animated GIF below, I have shown how to create drop down list in cells in Microsoft Excel with Data Validation Function. Share your views on this trick and how it helped you at your work in comments! To Subscribe to the courses go to Courses page and be effective user […]


Subscribe for Newsletter