From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Warnings to heed
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Warnings to heed
- [Instructor] Dynamic arrays in this new calculation engine are exciting, but there are a few things that I want to warn you about. There is no workbook for this video, so just follow along and take note of some of these traps. We've got customers, we service their aquariums, here they are, information about them and their aquariums. Let's filter this for aquariums that are over 80 gallons. Here we go. Equals, filter, open parenthesis, our array is this table, comma, include gallons we want ones that are over 80 gallons, close parenthesis. If there are none, then put none. Here is our dynamic array, and that blue line tells us so. Changes to our formula have to happen at the original formula, notice this is grayed out, we can not make a change to the grayed out formula. Let's look what happens if I try to change this from 80. Well I can't do anything, the formula disappeared. I'm going to hit escape. If I want to change this to 100, I had to change it in the original formula. We'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.