Help: Data Validation-multiple selections to appear in one cell separated by a comma

The direct answer is not, you can't use data validation to select more than one choice (at least I have never run across it).

I would suggest, include combinations within the data validation itself.

Also, a suggestion would be to turn the your DV list into a dynamic named range so it will grow as your requirements grow.

Create named range >> Ctrl + F3 >> Name: MyChoices >> Refers to: =Sheet1!$L$11:INDEX(Sheet1!$L:$L,MATCH(REPT("z",255),Sheet1!$L:$L))

Now for the DV in D4, use =MyChoices as the Source

One alternative.
Cell D5: =ConcatenateRange(L11:L14,", ")
//Ola

Please Login or Register  to view this content.

Source: link

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.