Data validation without duplicates - Excel Tricks

#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 ========================================= https://chandoo.org/wp/excel-add-drop-down-list/