- Let's take a deep breath, because we got a lot to do here. … The goal is to get a filterable list in columns B and C … that's controlled by a dropdown list in cell C-2. … The goal is to take our of-interest dishes … and be able to filter'em in columns B and C. … We want our dish and our sold year-to-date values. … And we want to control the filter by … a dropdown list in cell C-2. … Where does our sold year-to-date value come from? … It comes from over here, in our all-dishes list. … Now once we've got the dishes and the sold year-to-date, … we would like a total value in cell D-2. … Let's start by making our dynamic dropdown list. … Let's go to this cell, J-3, and say OPTIONS. … Now we want to be able to filter by beef, poultry etc. … =UNIQUE, … and our array is this column here. … And just press enter. … Now we've got all of the entries … that we need for our dropdown list. … Now here is something important. … I'm going to highlight all of these. … While I'm holding down the mouse button, look over …
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.