TextJoin Remove Duplicates but with an If Function filter

Question

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.

Excel 2016 and Office 365 are two different versions with different formulas for find Unique items. Do you have an Office 365 subscription? — Scott Craner, Feb 13 '20 at 22:19
You are missing a `""` for the first `IF`, so replace the last part of your formula `)))` with `),""))`. That said, depending on the answer to Scotts' question there may be a better way. Update your Q with some sample data and expected results — chris neilsen, Feb 13 '20 at 22:31

score 0 · Accepted Answer · answered Feb 13 '20 at 23:26

0

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

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

answered Feb 13 '20 at 23:26

Scott Craner

148,073
10
49
81

TextJoin Remove Duplicates but with an If Function filter

1 Answers1