Unique names from a list of names
Is there any formula in smart sheet which can show all the unique name from the column containing various names????
I have tried many formulas mentioned in various discussion in smart sheet community but none of them are working properly,
If possible, kindly share the link of discussion which can solve my problem or share the formula
Answers
-
Hi @CIEPL_1234
There are a couple of ways you could do this. Perhaps the easiest would actually be to create a Row Report from your sheet, then Group the Report by that column with the names!
Then you can collapse the groupings so you have one list of all the unique names, and if you expand each name you can see all the associated rows. Here's a free webinar that goes through this feature: Redesigned Reports with Grouping and Summary Functions
If you want to bring all the unique names into one cell, you could use a JOIN formula for this. You'll want to set up a text/number column, then I would personally use Wrap Text on that cell and a delimiter of CHAR(10), or a line break, to separate the values.
Try a structure like this:
=JOIN(DISTINCT(COLLECT([Name Column]:[Name Column], [Name Column]:[Name Column], <> "")), CHAR(10))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for your reply, I will try and will let you know if my problem is solved or not.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!