Download Excel File: https://ift.tt/2ZvPfrY
Learn how to filter the rows of a table with a List of Does NOT Contain Criteria using an Array Formula. See the Excel Worksheet Functions: SEARCH, ISNUMBER, MMULT, TRANSPOSE, ROW, FILTER Dynamic Array Formula, Also, catch a gimps of the functions: INDEX, AGGREGATE, IF, ROWS, SUMPRODUCT and more.
This complex Array formula is amazing because it uses traditional Array Array Functions like MMULT and TRANSPOSE and the new Dynamic Array Functions like FILTER, all with the new Excel Calculation Engine!!!