Forum Discussion

Scalatore's avatar
Scalatore
Copper Contributor
Jun 26, 2023
Solved

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...
excel
Formulas and Functions
office 365
  • mtarler's avatar
    mtarler
    Jun 26, 2023

    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.

mtarler's avatar
mtarler
Silver Contributor
Jun 26, 2023

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.

mathetes's avatar
mathetes
Silver Contributor
Jun 26, 2023
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!

Resources