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.
UNIQUE by column
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
UNIQUE by column
- [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 and are not repeated in the…
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.