I have a lookup field that lists every area code in each time zone. These are listed by zip code within each time zone so there are a ton of repeats. You can see them in the area_codes field:
I've tried to create a formula field (UniqueAreaCodes) to remove all the duplicates but as you can see it is still outputting some duplicates. I have tried ARRAYUNIQUE(area_codes) as well as
Any advice is greatly apprceiated.
The fields that area codes are in are individual zipcodes. Think of the zipcode you live in and all the surronding zip codes. They will all have the same listed area code(s) in that area. Some overlap, some are very large areas with 1 area code. So there will be many area codes of the same number listed per zipcode