Remove duplicates from a row?

cabbsman ✭✭✭✭
edited 01/11/24 in Formulas and Functions

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!