Returning Matching String Values Once

otavilog · 10/27/22

I have a {Client} row in an external sheet. Certain client name can appear multiple times. I am trying to have it listed once .

I tried DISTINC, MATCH and no luck.

=DISTINC({Client})

Michael Culley · 10/27/22

sorry I read that wrong. Let me change my answer.

Does using =join(distinct(collect( work for what you're doing?

Michael Culley · 10/27/22

=JOIN(DISTINCT(COLLECT(collectrange, criterion_range1, criterion1, criterion_range2, criterion2)), ", ")

otavilog · 10/27/22

Thank you. I realize I wasn't very clear.

This is what I have:

I get with your formula:

What I am trying to achieve:

Not sure if it is even possible....

otavilog · 10/27/22

Solved it: I applied this formula:

=IFERROR(INDEX(DISTINCT({Client}), [Row ID]@row, 1), "")

Only works if you add an additional column with numbers assigned. This is what the result looks like:

Answers