Forum Discussion
multi-select drop-down list
I have seen a pretty close functionality where you can select multiple options from a Drop List and every option is added next to the previous selection with a comma separating them. If this is what you want then you can use any of the static techniques (Text To Column) or Dynamic ones (Dynamic array functions) or Split by delimiter in Power Query to separate the result into multiple columns.
However, I personally think that by selecting multiple options, you are defeating the purpose of Data Validation. Further more, sorting and filtering may yield incorrect results.
If you want to read the Blog I mentioned, it is written by fellow Excel MVP Mynda Treacy, and here is the link:
https://www.myonlinetraininghub.com/select-multiple-items-from-drop-down-data-validation-list
Hope that helps
Nabil Mourad
- I have a similar need where we are asking users to choose from a drop down how data is entered into the applications they use. We are planning on taking the data into Power BI where we will transform the multiple values, just wanting the multi-select for the Excel sheet that will be the source for Power BI.
