Excel Dynamic Arrays: 4 Complex Filter Examples

/in /by

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/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2