Skip to main content

Hi,


I’m trying to get unique text values using ARRAYUNIQUE but the result is returning duplicate entries.


I have a lookup column called airlines with the values: American, Delta, Southwest, Southwest


I want the result American, Delta, Southwest.


But ARRAYUNIQUE({Airlines}) still returns American, Delta, Southwest, Southwest


Any ideas?

Hi @Erik_Paquet


Thanks for your post! Our hunch here is that there may be some small difference between the two “Southwest” values, perhaps a leading or trailing space.


If this isn’t the case, could you kindly reply with the field type that is being looked up, a screenshot of the lookup configuration, as well as the lookup values, so that we can get a better understanding of how to help?

Reply


Terms & Conditions