Remove duplicates from a row?
Is there a way to remove duplicate zip codes in a row of columns so only unique zip codes will be available when I concatenate them all into a combined zip code column?
Example: If I have 4 columns of zip codes and Col 1 and Col 4 are duplicates, I only want to show Col 1's Zip Code once when I combined all the columns into Col 5.
Where the result in Col 5 would be a concatenation of all zip codes on the same row with only one zip code instance of 95973 listed.
Help Article Resources
Check out the Formula Handbook template!