Array containing duplicates

[davidepstein22]

Hi all,

I have an array function that returns text separated by commas (e.g. "Dave, Tom, Dave, Mike...") and it contains duplicates when there is more than 1 match (i.e. Dave). What functions should I wrap around the array to remove the duplicates?

Thank you!

 

[Aladin Akyurek]

Hi all,

I have an array function that returns text separated by commas (e.g. "Dave, Tom, Dave, Mike...") and it contains duplicates when there is more than 1 match (i.e. Dave). What functions should I wrap around the array to remove the duplicates?

Thank you!

		3
Dave		Dave
Tom		Tom
Dave		Mike
Mike

<colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody>
</tbody>

In C1 control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(1-($A$2:$A$5=""),MATCH($A$2:$A$5,$A$2:$A$5,0)),ROW($A$2:$A$5)-ROW($A$2)+1),1))

In C2 control+shift+enter, not just enter, and copy down:

=IF(ROWS($C$2:C2)>$C$1,"",INDEX($A$2:$A$5,SMALL(IF(FREQUENCY(IF(1-($A$2:$A$5=""),MATCH($A$2:$A$5,$A$2:$A$5,0)),ROW($A$2:$A$5)-ROW($A$2)+1),ROW($A$2:$A$5)-ROW($A$2)+1),ROWS($C$2:C2))))