Excel Weekly Challenge: Filtering with Dynamic Arrays

This week's challenge involves the new Dynamic Arrays function: FILTER.

We want to filter a list of venues based on the capacity and the cost. Thus, we're filtering on 2 criteria.

Here is the video challenge:

You can learn more about the new Dynamic Array functions and Excel's new calculation engine at my LinkedIn course: Using Dynamic Array Functions (Office 365).

What's The Big Deal With Dynamic Arrays?

Dynamic Arrays and the new calculation engine behind Excel make life much simpler. One formula can return multiple cells' worth of result. This means writing fewer formulas; reduced possibilities for errors; everything remains integrated and dynamic.

Handy weapon to have in your arsenal when you're trying to get data to cooperate.

Where Can You Find Oz du Soleil

Oz's Courses on LinkedIn

List of Courses by Oz du Soleil in the LinkedIn Learning Library

• Excel Weekly Challenge
• Power Query (Get & Transform)
• Tracking Data Easily and Efficiently
• Power Query Tips and Techniques
• Excel: You Can Do This
• Using Dynamic Array Functions (Office 365)
• Excel in the Real World

Around the Internet

• LinkedIn
• YouTube: Excel on Fire
• OzduSoleil.com