How to filter cell for string reoccurrences/duplicates?

Question

My sheet has a cell with content:

Tomato, Potato, Beef, Tomato, Salmon, Beef

I want to remove all reoccurring string elements of this cell so that the new cell shows this:

Tomato, Potato, Beef, Salmon

I've tried to achieve this with the UNIQUE and TEXTJOIN functions so far, without success. Is it possible to apply FILTER to a cell?

score 2 · Accepted Answer · answered Oct 30 '20 at 12:04

2

Try this:

=TEXTJOIN(", ",true,UNIQUE(TRANSPOSE(SPLIT(substitute(A1," ",),","))))

answered Oct 30 '20 at 12:04

Marios

score 0 · Answer 2 · answered Oct 30 '20 at 12:57

0

or try:

=INDEX(TEXTJOIN(",", 1, UNIQUE(TRIM(FLATTEN(SPLIT(A1, ","))))

answered Oct 30 '20 at 12:57

player0

score 0 · Answer 3 · answered Oct 30 '20 at 17:59

0

This shorter one also works

=JOIN(", ",UNIQUE(TRANSPOSE(SPLIT(A1,", "))))

answered Oct 30 '20 at 17:59

marikamitsos

3 Answers3