Filter Unique Values from a List

Whether you have a small list or large list of items if you wanted to do analysis, you'd have to do some kind of filtering to teased our important information. In this video, I'll show you how to filter out unique values from a list in a column. I'll show three ways to do this: (1) with a PivotTable (2) with the Advanced Filter feature (3) with the Remove Duplicates feature .