Return a list of cell values if one criteria is met

KarineMul22_TPg

Hello,

I would like to return a list of Project IDs (four digits) that meet the same criteria , so I went for :

=JOIN(COLLECT({Project Summary MASTER Range Project}, {Project Summary MASTER Range Time}, "Yellow"))

Unfortunately, it comes back as an 8/16/20 etc digit long without any separation - is there either

1) an other function I could use

2) An additional function to separate the joined data in another cell?

Thank you

Paul Newcome

Yes. You would use the second portion of the JOIN function.

=JOIN(COLLECT(..........), "delimiter of choice")

Paul Newcome

Yes. You would use the second portion of the JOIN function.

=JOIN(COLLECT(..........), "delimiter of choice")