Remove duplicates from a row?

cabbsman
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.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!