Search code examples
excelexcel-formulatextjoin

TextJoin Remove Duplicates but with an If Function filter

I am using the new TextJoin function with a Match and a IF function as a filter. The statement works for the most part, but for every row that dos not meet the filter requirement it returns a "False". Is there a way to filter and not get a bunch of "False" returns but just the correct ones?

Here is my Formula:

{=TEXTJOIN(";",,IF(E5:E211="Austin",IF(MATCH(D5:D211,D5:D211,0)=ROW(E5:E211)-ROW(E5)+1,D5:D211,"")))}

It finds all the correct items, but Adds the Falses' too.

Solution

  • with an Office 365 subscription we can use the dynamic array formula:

    =TEXTJOIN(";",,UNIQUE(FILTER(D:D,E:E="Austin")))