From the course: Excel VBA: Managing Files and Data

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Find unique items using xlFilter

Find unique items using xlFilter - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Find unique items using xlFilter

- [Instructor] One very useful way to analyze your data in Excel, is to identify unique values within a dataset. For example, you might look at your orders and see how many different States are represented. In this movie, I will show you how to use VBA to create a unique values filter, and also how to use the new unique worksheet function. My sample files, 0105, find unique. And you can find that in the chapter one folder, of the exercise files collection. I'll start with the VBA code, that we'll use to create a unique values filter. And that filter will appear in the same position as the original list. The data will work with run from cell A2 to A9, and the code will refer to that range. I'll press alt-F11 to move to the visual basic editor. And here at the top, I have a code module which will use the current region and create a filter. The code to create this filter is actually fairly straightforward. We have the…

Contents