Returning Matching String Values Once
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})
Answers
-
sorry I read that wrong. Let me change my answer.
Does using =join(distinct(collect( work for what you're doing?
-
=JOIN(DISTINCT(COLLECT(collectrange, criterion_range1, criterion1, criterion_range2, criterion2)), ", ")
-
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....
-
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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!