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

 

 

 Helpful Resource:

MOTH-excel_expert470x63

 

6

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin