Get the unique values from an Excel list

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.