Unique List of values from multi choice list column
Hello, I've searched through a lot of the help articles and can't see exactly what I'm looking for. I have a document with a column which is a drop down list - multiples permitted.
I want to create a single list of values from this that exist - is that possible? E.g. I want to create a new unique list either on a new sheet or on a report of the countries that have been selected:-
Any help would be really great!
Thanks
Debs
Answers
-
I'm not fully understanding what you are asking. Possibly you are trying to determine whether or not some permitted values are never being selected.
If so, you know the permitted values that are POSSIBLE (from the column properties), so from that you can do a countifs for each one where you check for that value with a find @cell command.
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