Create your own Sorting Criteria in Excel

Data Sorting is one of the most frequently used features in Excel. Some common examples include sorting alphabetically, by value (largest to smallest or smallest to largest), by day of the week (Mon, Tue, Wed..), or by month names (Jan, Feb..).

Sorting Criteria in Excel - Sort

While these are some inbuilt sorting criteria, you can create new criteria according to your data. For example, I have some KPI data as shown below, and I want to sort this list from High to Low. While excel does not provide these sorting criteria, in this blog post I will show you how to create it.  

Sorting Criteria in Excel - Sorted Data

How to Create Custom Sorting Criteria in Excel

  1. Go to File –> Options.
  2. In the Excel Options Dialogue Box, select Advanced from the list in the left pane. Within Advanced selected, scroll down and select Edit Custom List.

Sorting Criteria in Excel - Custom Sorting Dialogue box

  1. In the Custom Lists dialogue box, type your criteria in the box titled List Entries. sType your criteria separated by comma (High, Medium, Low) [you can also import your criteria if you have it listed].

Sorting Criteria in Excel - Criteria Entry

  1. Click Add
  2. Click OK

To Sort Data based on Custom Criteria in Excel

  1. Select the data set.
  2. Go to Data  –> Sort.
  3. In the Order drop-down list, select Custom List.

Sorting Criteria in Excel - Selecting Custom List

  1. Select the criteria and click OK.

You May Also Like the Following Excel Tutorials:

  • Jiggi says:

    Great, thank you!

  • >