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.

Solution 1

Solution 1

From the course: Excel: Using Dynamic Array Functions (Microsoft 365)

Start my 1-month free trial

Solution 1

“

(dance music) - [Instructor] You're back! Did you get it? I hope so, if not, check it out, I'm about to dive in. First thing I'm going to do is filter and get rid of these comedies. Equals filter.. the array.. here. Comma, include what? Where the genre does not equal comedy. And we aren't worried about whether this is empty or not, so I'm going to close the parentheses, enter. There are all of the movies, no comedies. Next, I'm going to sort by release date, and you could of done this any number of ways, I'm going to do it this way. Equals, sort by, open parentheses, I want to sort this array, comma, by what array? By this one. Sort order, comma, we want ascending because we want the oldest date on top. One, close parentheses, enter. Okay, let's visually check to see if this makes sense, Mirrored Truth is on top, yes, Mirrored Truth was released in 1957, Until February: The Prequel that was 2015, great, that's perfect! Next, list the dates that we're going to see them, every four…

Contents