Remove duplicate

Gaurav Chauhan
Gaurav Chauhan ✭✭✭✭✭✭
edited 06/17/22 in Formulas and Functions


Can you suggest how can I remove any duplicate or not consider a duplicate.

Eg. the below formulae populates the response in the cell as :::: Apple , Apple

=INDEX(COLLECT({Product Supported}, {Project ID}, CONTAINS("ABC", @cell)), 1) + " , " + INDEX(COLLECT({Product Supported}, {Project ID}, CONTAINS("CDE", @cell)), 1)

Is there a way, it can determine if both values are the same and populate that value only once


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!