How To Find Unique Values Using Advanced Filter In Excel

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
In this video I explain how to create a list of unique values with the Advanced Filter feature in Excel. This is a follow-up to a previous video where I shared 2 other ways to list unique values using the Remove Duplicates feature and a VBA macro.

Here is the link to the previous video.    • 2 Ways to Remove Duplicates to Create...  

The Advanced Filter feature of Excel has an option called Unique Records Only that creates the list. We can take a column of cells that contains duplicate values, and create a list of the unique values only in another column on the sheet.

The disadvantages of the Advanced Filter technique are the output must be on the same sheet as the data range, and the formatting is not pasted to the output. Otherwise, it's another great option for creating a list of unique values and removing duplicates.

Here is the link to the page where you can download the Excel file to follow along. https://www.excelcampus.com/vba/remov...

Click here to checkout the Filters 101 Course and learn more about the Advanced Filter feature. https://www.excelcampus.com/filters

Click here to join the Excel Campus newsletter and receive a free gift. https://www.excelcampus.com/free

Please leave a comment below with any questions or suggestions for other ways to create a list of unique values.