Prevent Duplicate Entries in Column / Cell in Excel | Data Validation




About this tutorial:

Video duration: 00:04:47
You can automatically prevent duplicate data entries in the cell using data validation option with countif function in excel. It is applicable all versions of excel 2007, 2010, 2013, 2016, 2019, office 365.

We will take example of invoice numbers in a column. We don’t want any duplicate invoice number in the specific column. In this advance trick of excel, we can stop duplicate entries in excel.

✅Download File 🔸
#veertutorial #countif #excel
English Video Playlist 👉👉👉👉👉
________________________________________________
Google Sheets Video 👉…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

2 thoughts on “Prevent Duplicate Entries in Column / Cell in Excel | Data Validation

    Rohit Kumar

    (May 22, 2020 - 4:06 pm)

    Sir kisi coloumn ki certain range me ek drop down list kaise lgate hai pr vo searchable honi chahiye

    Rohit Kumar

    (May 22, 2020 - 4:06 pm)

    Nice vedio sir

Leave a Reply

Your email address will not be published. Required fields are marked *