Is there any possibility to mark more values in drop-down list and to have them in one single row?

This is the way I found but still it is not inside a single row...

My DDT

And this is actually what I would like to have but WITHOUT VBA if possible..

With VBA

1 Answer

Very easy.

Here is an example. Setup DV in cell B1 using a list in column D:

Then copy cell B1 downward (each of the copied cells will also have DV)

In C1 enter:

=TEXTJOIN(",",TRUE,B:B)

Then make your selection(s) in the B cells:

NOTE:

This technique:

• allows as many items as you want to be concatenated
• allows the same item to be concatenated more than one time.
• assumes you are using a version of Excel that supports TEXTJOIN()
• does not rely on VBA

4

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy