- [Instructor] Here we've got a list of data … about colors of paint, the size of the tubes, the count, … whether it's on the shelves or in the back room. … We would like to extract a list of the distinct products. … Notice that we've got Neon Pink, three ounce, … in rows nine, 10, and 22. … I just want to see Neon Pink, three ounce, once. … This means that we have to use the unique function … across two criteria or two columns. … Let's do it. … Equals unique, … open parentheses. … Where is our array? … We want these two. … Column, compare by row or by column. … We want by row. … So we're going to type false, … comma, we want one or more times, … so false again, closed parentheses, enter. … And this is exactly what we wanted, … a list of the distinct products, … Neon Pink, three ounce, … is in our final list just one time. … …
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.