- [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, …
AuthorOz du Soleil
- Working with spills
- Using the UNIQUE function
- Sorting with dynamic arrays
- Comparing SORTBY and SORT
- Unstacking records with SEQUENCE
- Creating intelligent filters
- Randomizing data with RANDARRAY
- Combining dynamic arrays in drop lists and more
Skill Level Advanced
1. What to Know Before Using the New Functions
Warnings to heed6m 19s
Horizontal SORT3m 33s
9. Putting It All Together
10. Challenges and Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.