From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

TOCOL

TOCOL

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

TOCOL

“

- [Instructor] Now here is a variation on the previous video on UNIQUE. This is exciting. For years, a lot of Excel users have wanted a way of taking an array like this and stack it all up into one column so that it's useful. Maybe you've got people's names and then shifts, and you would like to be able to see just a tall column of how many people are in the list more than once. Only once. So many uses for what I'm about to show you now. So, our favorite Excel experts have given us their favorite functions. Our goal is to find out which functions are in this data set only once. So let's try UNIQUE. We did that in the previous video. Let's see, UNIQUE, double click, get this whole array and enter. No, UNIQUE does not work. This is what we have to do, =TOCOL. Return the array as one column, and you also see that there's a to row which returns an array as a single row. Let's do TOCOL, double click it. The array is right…

Contents