Sort by Custom List
Excel Tips and Tricks

Excel Tips: Sort data by Custom List

Many times it happens when we are not able to sort our data as per our requirements. We have to take some support column to sort the data. For example if you have month wise data points. Month name is in text format like Jan, Feb, Mar etc. If data is not sorted by month and we have to sort the data by month name. We would not be able to sort the data using normal sort method by month because month name is a text. If you will sort it in ascending order then it will show month name like Apr, Aug, Dec etc. and If you will sort it in descending order then it will show month name like Sep, Oct, Nov etc.

 

Sort by Custom List
Month wise data points

 

To sort the data with proper month name (like- Jan, Feb, Mar…) we will sort this table with custom list. Below are the steps:

  • Select the data and click on Sort available in Data tab.
Sort Feature
Sort Feature
  • Sort window will be opened.
  • Select Month in Sort by drop-down.
  • Select Custom List in order drop-down.
Sort Window
Sort Window

 

  • Custom list window will be opened.
  • Select Jan, Feb, Mar, Apr, May, Jun List as given in below image.
Custom list window
Custom list window

 

  • Month will be sorted by proper manner like below given image.
Sorted data by month
Sorted data by month

Click here to download this Excel workbook for practice.

You can create your own custom list that can be used to sort your data.

Watch the below given video how create own custom list in Excel.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com