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.
Watch video How To Find Unique Values Using Advanced Filter In Excel online without registration, duration hours minute second in high quality. This video was added by user Excel Campus - Jon 09 November 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 355,699 once and liked it 2.2 thousand people.