Remove duplicate

Gaurav Chauhan

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

Paul Newcome

Maybe try this:

=JOIN(DISTINCT(COLLECT({Product Supported}, {Project ID}, OR(CONTAINS("ABC", @cell), CONTAINS("CDE", @cell))), " , ")