From the course: Excel: Productivity Tips

Unlock the full course today

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

Extracting unique values from a list

Extracting unique values from a list - Microsoft Excel Tutorial

From the course: Excel: Productivity Tips

Start my 1-month free trial

Extracting unique values from a list

“

- [Presenter] All right, this next tip is a really useful one. I'm going to show you how to extract unique values using the Advanced Filter tool. Now in Excel, there are a number of different ways to remove duplicates. You can use the Remove Duplicates tool, you can use Advanced Filters, you can even use PivotTables or Power Query all to accomplish the same end result. Now, I actually like the Advanced Filter approach the most because it's the most flexible. And what I mean by that is that it allows you to either filter the list in place or overwrite the original list which is how the remove duplicates tool works by default or you can copy only the unique values to a new worksheet location. So let's say you have some data like this. I've got dates, product ideas, products, maybe this is transaction data where product might sell on multiple days or even multiple times within the same day meaning that that column C is likely…

Contents