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.

=DISTINC({Client})

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!