Return unique values from a row
Hi,
I am trying to find a formula where I can return unique value from within a row.
The range would be column2:column5 and returning only the unique values within that range to unique value column. eg: A,B,C
Best Answer
-
Hi @Kris Klein. I believe the following is the result you're looking to achieve...
=JOIN(DISTINCT([Column2]@row:[Column5]@row), ",")
Let me know if this works for you.
-Jen
Answers
-
Hi @Kris Klein. I believe the following is the result you're looking to achieve...
=JOIN(DISTINCT([Column2]@row:[Column5]@row), ",")
Let me know if this works for you.
-Jen
-
Thank you Jen this worked a treat
-
That's great, @Kris Klein.
Also, thank you for your engagement and contribution to our community. Your inquiry is likely to assist other members across time.
If you appreciate my response, please recognize the effort by with an "Insightful" or "Vote Up" selection. Thanks!
-Jen
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!