Multiple choice technology

To create a list of unique items, based on a list that contains many duplicate entries, which Excel feature would you use?

  1. Advanced Filter

  2. Custom Sort

  3. AutoFilter

  4. Data Validation
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Advanced Filter feature in Excel can extract unique records from a list when the 'Unique records only' checkbox is selected. AutoFilter hides duplicates but doesn't create a separate list. Custom Sort reorders data, and Data Validation controls input - neither removes duplicates.

Keep practicing — related questions