Skip to main content

ARRAYUNIQUE not working

  • May 13, 2020
  • 1 reply
  • 25 views
E

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?

1 reply

J
Forum|alt.badge.img+5
  • Joe_H
  • Participating Frequently
  • June 30, 2020

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?

Terms & ConditionsAccessibility statement