- [Instructor] Let's use Unique to extract columns. … We're going to do this horizontal. … We've got 12 flags … and a lot of 'em have same color combinations. … When we extract the distinct flags, … we're going to get a result that shows each combination … with no repeats. … When we do the unique flags, … we're going to get a result that shows … each color combination that is only represented one time. … Let's do the distinct. … Equals unique. … Open parentheses. … Where's our array? … It's right here. … Comma, compare by column, yes. … That's exactly what we're doing. … Type in True, … comma, occurs once, false. … We don't want that yet. … Close parentheses. … Look at that. … We've got seven distinct color combinations, … which means the remaining five are repeats. … Now let's get at the unique flags. … How many are truly original? … Equals unique. … Open parentheses. … Our array. … Comma, by column, you guessed it, True. … Comma, only once, True. … Close parentheses, bang. … Just these three combinations stand alone …
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.