Excel Dynamic Arrays: 4 Complex Filter Examples
Excel's Dynamic Arrays are fascinating ... and complex. Here is a second video where I dig into the logic of the FILTER function.
You'll see examples of the FILTER function, filtering on 2 criteria where I play with the logical operators:
Greater Than
Less Than
Equal To
Not Equal To
Smaller Than or Equal To
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/ins...
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2