Prevent Duplicate Entries in Column / Cell in Excel | Data Validation
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 🔸 https://bit.ly/2Yetvnt
#veertutorial #countif #excel
English Video Playlist 👉👉👉👉👉
________________________________________________
Google Sheets Video 👉 https://bit.ly/2VofxfC
Excel 👉
Excel Pivot Table 👉
---------------------------------------------------------------------------
Hindi Video Playlist
________________________________________________
Excel 👉 http://tiny.cc/mnypaz
Tally ERP9 👉 http://tiny.cc/951paz
MS Access 👉 http://tiny.cc/j91paz
HTML5 & CSS3 👉 http://tiny.cc/w81paz
GST 👉 http://tiny.cc/ba2paz
---------------------------------------------------------------------------
Facebook ► / exceltips101
Twitter ► / veer_tutorial
Visit ►www.veertutorial.com
**********************************************
