Formula to display unique entries
I have a form that is tied to a source sheet and I have a separate data sheet where I am trying to obtain data on the list of cities. Is there a formula I can use to display the unique entries on a data sheet in column form based on what is input on the source sheet? Would this be sensitive to whether the cities are typed with capitals or not capitals? Example, would City of Chesapeake and city of chesapeake both be seen as the same?
Ex: I would want to see a list for all unique entries as the one below:
City of Chesapeake
City of Manassas
City of Suffolk
City of Waynesboro
etc.
Thanks
Answers
-
You need to explaion yourself better.
Are you asking for a formula to return a list of rows where X city is listed in 'select town permits'.
-
I am basically looking for a formula to display all the unique entries in a separate sheet that are listed in the column called "Select City or Town Permits"
Does that make sense?
-
You want all unique entries in the column?
-
Yes, that is correct @BullandKhmer
-
Hi @rabia
The easiest thing to do here is use a JOIN function to Join together all your multi-select values from one column into one multi-select cell. This will automatically strip out any duplicates!
Here's an example in the same sheet:
However you can do this in a cross-sheet formula, like so:
=JOIN({Multi Select Column}, CHAR(10))
The CHAR(10) is the break between multi-select values.
This would indeed be case-sensitive, because a lower case value typed would be selected as a new selection in your multi-select column.
Let us know if that helped!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @Genevieve P.,
Thank you, yes the Join function works well for this, but is there a way for me to then take those unique entries in the single cell and have each of them displayed in separate rows?
Similar to this:
-
Hi @Rabia
There currently isn't a direct way with a formula to parse out a multi-select cell into multiple, individual rows. Please vote on this Enhancement request post to add your voice to this Idea!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @Genevieve P., I did vote on that post! I appreciate your help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!