(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! …
Author
Released
3/7/2019- 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
Duration
Views
Related Courses
-
Introduction
-
1. What to Know Before Using the New Functions
-
Warnings to heed6m 19s
-
2. UNIQUE
-
Unique vs. distinct2m 15s
-
Multiple criteria1m 19s
-
UNIQUE by column1m 51s
-
-
3. SORT
-
Horizontal SORT3m 33s
-
4. SORTBY
-
Basic SORTBY2m
-
Horizontal SORTBY3m 2s
-
SORTBY vs. SORT2m 48s
-
-
5. SEQUENCE
-
Basic SEQUENCE2m 35s
-
Unstack records4m 11s
-
-
6. FILTER
-
FILTER logic: Plus2m 2s
-
FILTER logic: Asterisk2m 39s
-
FILTER logic: Equal2m 1s
-
FILTER logic: Minus2m 13s
-
FILTER Logic: Greater Than2m 16s
-
Crazy logic: Three criteria5m 11s
-
-
7. RANDARRAY
-
Randomize data2m 6s
-
Generate random data2m 23s
-
-
8. SINGLE
-
9. Putting It All Together
-
The spilled range operator5m 24s
-
Dynamic drop-down list5m 45s
-
-
10. Challenges and Solutions
-
Challenge 145s
-
Solution 13m 47s
-
Challenge 21m 36s
-
Solution 24m 22s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Solution 1