#ExcelDropDownBox #DataValidationExcel

Validating your data as you type can prevent any surprises when you are doing analysis / followup on the data. Thankfully, Excel has the right tools to do it. Incell dropdown 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
=========================================
https://chandoo.org/wp/exceladddrop...