Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

ARRAYUNIQUE not working

Topic Labels: Formulas
381 1
Showing results for 
Search instead for 
Did you mean: 


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

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?