Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

ARRAYUNIQUE but for text strings

cancel
Showing results for 
Search instead for 
Did you mean: 
Natalie_Bates
6 - Interface Innovator
6 - Interface Innovator

ARRAYUNIQUE does not appear to work on text strings that have spaces. For some reason, it seems to work on text strings that are a single unbroken word.

I really need this for rollup fields that read in data from a junction table, as some of the data repeats. The rollup lists for a single record can be quite long, and the rollup fields are for humans to glance at and use to make decisions, so having several repeating strings makes it a lot easier for a person to overlook important data.