ARRAYUNIQUE not working

Topic Labels: Formulas
1597 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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?

1 Reply 1
Airtable Employee
Airtable Employee

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?