Forum Discussion
Concatenate Drop Down list
Good morning to everyone, this is my first discussion. I need your help about excel: I need to create a excerl workbook with 5 to 6 column where there is the same drop down list apply on every column.
Until now it's simple, but my problem came after: after i choose the value from the drop down list of the first colum, in the second column the drop down list must present the same value list minus the value select in the first colum, and so on. It is possible?
Thank you very much for every suggertion.
PS: i can not use macro o vba
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.
3 Replies
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!
