- [Instruction] We've got a sports club. … The sport doesn't matter, … we're here talking about dynamic arrays. … Specifically we're going to talk about filtering. … We've got data about the matches that we've played, … the opponent, the scores, et cetera. … We would like to extract a list of data … that shows all of our wins … or where we scored at least 30 points, … whether we won or lost. … We're going to filter … and we're going to put our cursor right here. … Equals filter. … Open parentheses. … Our array is this table. … We're going to hover over the top of this table, … wait for that black arrow. … Press the mouse. … Go to the right, let go. … That's our array. … Comma, what do we want to include? … Our first criteria is all of our wins. … Open parentheses. … Hover over the Column D … where we have our Won and Lost. … Select that. … Equals, we want W in double quotes. … Close parentheses … and our second criteria. … And because we want an Or that's the plus sign. … Plus sign, now open parentheses for our second criteria. …
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.