Hi.

I'm using this formula to return keywords based on a search of one cell 
=TEXTJOIN(">",,IF(ISNUMBER(SEARCH(Keywords!$A$1:$A$20,F2)),Keywords!$B$1:$B$20,""))
How can I avoid duplicated keywords if the search finds two target words in F2 with the same Keywords?

eg
Keywords! A1= Red B1=Colour
Keywords! A2= Blue B2=Colour

If F2 contains 'Red' and 'Blue' I only want 'Colour' returned once (as opposed to 'Colour>Colour' which is what I currently get)

Thanks.