Remove duplicate

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

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!