About this tutorial:
Video duration: 00:09:02
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