Skip navigation

Using Advanced Filter to create unique lists from repeating field data

Using Advanced Filter to create unique lists from repeating field data: Excel 2016: Managing and Analyzing Data
Using Advanced Filter to create unique lists from repeating field data: Excel 2016: Managing and Analyzing Data

Based on a list that contains duplicate records, you can create a "clean" list with all duplicates removed by using the Advanced Filter feature and ignoring the Criteria range completely. Select the option Copy to another location, select an address to hold the results, and check the Unique records only option.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
93,649
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now