i-nth logo
Get the unique values from an Excel list
7 September 2013

Today we will see how to get the unique values from an Excel list/range using three different methods:

  • Removing duplicates.
  • Using advanced filter.
  • Using array formula(s).

The sequence of the methods corresponds to the degree of difficulty, implying that the method of array formula is probably the most difficult to implement.

Full article: Get the unique values from an Excel list

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us