Dynamic comma delimited list

[coolkev99]

I'm trying to create dynamic selections by entering text "x" into the spreadsheet cells. It will pull from an array? to create a comma delimited list that will change if I add/remove selections. I didn't think this would be that difficult, but my limited knowledge is showing. Below is an example of how it would work/look. Could anyone please help me on this?
array.jpg

[bebo021999]

Try:

Please Login or Register  to view this content.

If more than 4 items, VBA is best choice.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[RaulSerg]

I don't have dynamic arrays here at work, so can't check but trying something along the following approach: =TEXTJOIN(“, ”,TRUE,IF(criteria_range=“X”,A2:A26,“”))

[RaulSerg]

btw - =TEXTJOIN(“, ”,TRUE,IF(criteria_range=“X”,result_range,"")) will have to be array-entered this with Ctrl+Shift+Enter

a formula that might work without would be maybe: =TEXTJOIN(", ",TRUE,FILTER(result_range,criteria_range="X","") - give it a try

[coolkev99]

I will try this, and I think it will be sufficient. I will follow up later.

[coolkev99]

Try:

Please Login or Register  to view this content.

If more than 4 items, VBA is best choice.

This worked great, however it leaves a trailing comma. Not a real big deal but I thought I'd try to avoid it. I found a custom function that worked great within the cell, however if there is nothing then it throws an error.

Works like this:

Please Login or Register  to view this content.

So then we have:

Please Login or Register  to view this content.

This all works great until there is nothing in the cell. Then I get the #VALUE! error. Anyone have an idea how to fix this from happening?