Forum Discussion
Concatenate Drop Down list
mathetes Ok so I added a few options in your file. Your original doesn't try to make them fill the drop down from Left to Right so I added another set that gives NO list until the prior dropdown is given a value. I then created another option where the order does NOT matter but no duplicates can be selected and this option only requires 1 dynamic filtered list. Note that in both the original from John and this Left to Right option I give can be 'tricked' to have duplicates but the last can't (as easily) be tricked.
I've attached an example--thanks for the opportunity to create something new. This takes advantage of the FILTER function, and its capabilities to create a list on the fly that can be used as a list for data validation. Here's a video that first was used by Microsoft to introduce the capabilities of dynamic array functions, FILTER being one of them.
By the way, the word "concatenate" generally refers to connecting things together to make a larger word or text string; what you're asking to do is more akin to dis-connecting or diminishing.
mathetes Ok so I added a few options in your file. Your original doesn't try to make them fill the drop down from Left to Right so I added another set that gives NO list until the prior dropdown is given a value. I then created another option where the order does NOT matter but no duplicates can be selected and this option only requires 1 dynamic filtered list. Note that in both the original from John and this Left to Right option I give can be 'tricked' to have duplicates but the last can't (as easily) be tricked.
- Good job refining the original. In my mind, reflecting back on it, I realized there'd be a way to streamline the subsequent lists, so only a single starter list could suffice with a single second that is constantly updated with any choices in any order. You actually did it!