Array Formula: Filter Rows with List of Does NOT Contain Criteria – Excel Magic Trick 1595

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!!!

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.