- [Voiceover] Alright you all let's … do some sorting horizontally. … Our sort by column. … Here, we host a story telling show. … We've had twenty five shows and here are each … of the story tellers, our performers. … We can see that some people, like Gaston, … has performed in multiple shows. … But now we have a question, have the same four people … ever been in the same show together more than once? … That's not easy to answer right now … because people are in shows in different order. … Gaston went second in one show, … he went first in one show, went last in one show, … therefore it would help us if we could get the … names sorted ascending and then we could easily compare … from show to show if the same four … people were, showed up multiple times. … Let's start here in cell G3, performers. … Enter. … Equals. … Sort. Open parenthesis. … Our array, we just want to grab this row. … Comma, we don't need to sort index. … Comma, sort order, we can choose one for ascending. … Comma, sort by column, true. …
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.