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.
Crazy logic: Three criteria
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Crazy logic: Three criteria
- [Instructor] Yes, we are about to do some crazy filtering. We're going to filter by multiple criteria. The goal is to get you thinking about filter logic. How these can be put together and how you can think through what's going on or what you need. So, this is more of a mental exercise, and I invite you to make up your own examples and play with them. Play with the different operators and string different criteria together. Here, we've got addresses, lawn size, bedrooms, and the square foot of each house. Now, let's make this wild, crazy formula. Equals, filter, open parentheses. Our array, our array is this table. I like the columns, comma. Our first criteria, open parentheses. We want lawn. I like that column. Does not equal small. Close the double quotes, close the parentheses. Now we want to minus and then our second criteria. Open parentheses. We want square feet less than 4,500. Close parentheses. Multiply. Multiplication, that's the asterisk and that means and. Our final…
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.