The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis.

This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will show unique values.  From there you can copy and paste outside the Pivot Table.

DOWNLOAD WORKBOOK

Filter Unique Records

 

 Helpful Resource:

MOTH-excel_expert470x63

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Filter & Search The Search box within the Filter button is powerful if you know how to use it to your advantage.For example, if you had a list of customers the Search box allows you to find specific customers by typing in a few letters only, allows you to add a selection to your filtered lis...
Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to.For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text.You can easily check this by highlighting that column an...
Split First & Last Name Using Text to Columns There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns.One way is to use the Power Query method, which is great if you have lots of data that gets added each day, ...
Autofill Formulas in an Excel Table One of the advantages of using an Excel Table is the ability to autofill a formula all the way down your data without having to copy and paste.When you write a formula anywhere in your Excel Table, it will automatically fill down and up within that column.As you add extra...