Data validation without duplicates – Excel Tricks

About this tutorial:

Video duration: 00:09:02
#ExcelDropDownBox #DataValidationExcel

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, Excel has the right tools to do it. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell. But what if you want to set up data validation list without duplicates?

For example workbook and more tips on Data Validation dropdown boxes, visit

Post Author:

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