Hello
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
ARRAYUNIQUE(ARRAYFLATTEN(area_codes)). These provide the same result. I've also tried a myriad of other complex formulas with no luck. I think part of the problem is that area_codes field is seperated by a carriage return and is not all one string. I tried to put that field into a continuous string first before using the array formula. Still no luck.
Any advice is greatly apprceiated.
