Formula Help needed for Comparing Two Arrays in Excel 365

I'm having trouble finding the right formula in Excel 365 to compare a column in an dynamic Table array with a separate dynamic list and having the formula output a variable list of items from a diff...

excel

Formulas and Functions

office 365

tmehringer01
Jan 19, 2024
Harun24HR Works like a charm! There are some advanced functions in there that I'm going to need to dig into to understand. Looks like the formula even caught one output that I missed.

Looks like they need to pay you more! Thanks again for your help!

Lorenzo

Silver Contributor

Jan 19, 2024

tmehringer01

One alternative with 365:

=TEXTSPLIT(
  TEXTJOIN(";",,
    MAP(CriteriaList,
      LAMBDA(crit, TEXTJOIN(";",,FILTER(Table1[Document'#], Table1[Criteria]=crit, "")))
    )
  ),,";"
)

sample.xlsx12 KB

Harun24HR
Bronze Contributor
Jan 19, 2024
Well. But TEXTJOIN() have a character limitation and we must be aware of that for large data set. For small data set, this is a good alternative.
- Lorenzo
  Silver Contributor
  Jan 21, 2024
  Harun24HR
  
  But TEXTJOIN() have a character limitation
  Agree, 32767 Chars

Forum Discussion

Formula Help needed for Comparing Two Arrays in Excel 365

Resources