From the course: Excel VBA: Managing Files and Data

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

List unique values from a data set using UNIQUE

List unique values from a data set using UNIQUE

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial Buy for my team

List unique values from a data set using UNIQUE

“

- [Instructor] Recent updates to Microsoft Excel have added some functions that you can use to manipulate data inside of a worksheet. In this movie, I will show you how to use the Unique function. My sample file is 01_08_Unique and you can find it in the Chapter 8 folder of the Exercise Files collection. Elsewhere in this course, I showed you how to create a unique values filter that displayed unique values in a list, but kept the list in the same place. In this movie, I will show you how to create a formula in cell C2 that will find all of the different or unique values from the range A2 through A9. And all we need to do is create a formula. So in cell C2 I'll type equal, and then unique. The array, which I will select, will be cells A2 through A9. I don't want to go by column. That's implied when there's only a single column of data, and I also don't want to find values that occur exactly once. I am looking at the formula argument list. So I just want unique values from A2 to A9…

Contents