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.
Basic SORTBY
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Basic SORTBY
- [Instructor] We've got this movie ratings data and we can see that City from Above got ten four-star reviews, 48 one-star reviews, this must be a pretty bad movie. But anyway, we want to retrieve the movie title and the genre. And we want it sorted two ways. We want the genre sorted first, ascending and then we want them sorted by the average descending. Sort by is going to allow us to do that. Let's grab our headers, right click, copy, and we're going to put our data here, paste. Now let's sort by equals, sort by, double click. What array do we want to sort, we want to sort this because this is what we want to retrieve. Comma, we want it sorted how, we want it sorted first by the genre. Highlight the genre, comma, we want it sorted ascending, so that's one, comma, we want to sort again, we want to sort by the average, highlight the average column, comma, we want that sorted descending. So that's going to be negative one, closed parentheses, hit Enter, there we go. Now I'm going to…
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.