I have an ENUMLIST with “Auto-Complete Other Values” set. It works fine except that the list is give is not in alphabetical order. I’ve tried usind SORT() but it doesn’t display it correctly because some of cells it selects are themselves a list because its an ENUMLIST. So I see
A,
B,
A,B,C
B,D
Anyone know how to sort it alphabetically and only show indiviual items?
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |