Validating your data as you enter it can help you avoid surprises when analyzing/tracking the data. Fortunately, Excel has the right tools for this. Drop-down lists or combo boxes built into cells can help you select a value from a valid list and enter it into a cell. But what if you want to set up a data validation list with no duplicates?

For a sample workbook and more tips on using drop-down fields for data validation, see
=======================================
https://chandoo.org/wp/excel-add-drop-down-list/

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.