In previous versions of Excel when you had a drop-down list that contained duplicates those duplicates would show up in the drop-down list. This has been fixed in the latest versions of Excel. The duplicates are now removed.
Tag Archives: Data Validation
Display an Excel Pop-up Message Without a Macro
Data Validation to the rescue
Would you like to display a pop-up message when a user enters a value into a cell? You don’t need a macro to achieve this.
Time to Play with Dynamic Arrays
Let play time begin
Many things that were hard or complex are now much simpler. Creating dynamic drop down lists based on previous selections used to be tricky in Excel. Dynamic arrays make it straightforward.
Validating Data Validation in Excel
Part One
The most common type of Data Validation in Excel is a drop down list. In the example below I allow the user to select a year, then a month (using a drop down) and then enter a valid day in the month.
Simple Excel Drop Down List
Quick Solution
A drop down list in Excel can help speed up data input and ensure the user has entered a valid entry. If you have only a few choices, creating the drop down can be a quick process.