Return results from multiple values- JOIN COLLECT HAS

Ann M

I need to return data from column5 separated by comma if a record appears in column6 which is a drop down list that can have multiple values per cell.

This is the formular that works only when there is one value in the cell..

=JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], "2"), ", ")

This formular gives me INCORRCET ARGUMENT SET =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], HAS([Column6]:[Column6], "2"), ","))

I want results to be "Test, this, should, works, truly"

Adam Murphy

Hi Ann,

You are very close, give this a try: =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], HAS(@cell, "2" )), ",")

Hope this helps!

Adam Murphy

Hi Ann,

You are very close, give this a try: =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], HAS(@cell, "2" )), ",")

Hope this helps!

Ann M

Thanks Adam, that works beautifully!

I would like to understand why @cell works rather than the column?

Adam Murphy

Hi Ann, you need the @cell because you are trying to evaluate each individual cell within the column, not the column all at once.