Returning Matching String Values Once


I have a {Client} row in an external sheet. Certain client name can appear multiple times. I am trying to have it listed once .

I tried DISTINC, MATCH and no luck.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!