From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Horizontal SORT
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Horizontal SORT
- [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. That's exactly what we need…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.