How to Create Custom Sort List in Excel (Easy Step-by-Step)

Показать описание

In this video, I will show you how to create your own custom sort list in Excel

While there are already some inbuilt criteria that you can use to sort in Excel (such as alphabetically, by numbers or dates), in some cases you may have a need to use a custom sort criteria.

For example, you may want to sort based on High, Medium, Low.

In such a case, you can create your own sorting criteria and then use this criterion while sorting the data.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Рекомендации по теме

Комментарии

Hi Sumit.. great tip. Many people don't know about Custom Lists or if they do, they don't know that they can be used as a custom sort order. Thanks for sharing this one.. very useful and powerful.. and can eliminate the need to add a helper column to accomplish the goal. Thanks and Thumbs up!

wayneedmondson

You are a genius, Sumit :-). You solved a very serious issue for me. Thanks a ton!

srinivasannarayanaswami

Wow, I didn't know that..This tip will come in really handy..Thanks for sharing, Sumit

mikevanwieringen

again another useful video-thank you so much Christine_NYC

christinebracken

Is there anyway we can sort the column headers?? e.g. if we have many columns in addition to week and performance, can we arrange them in a particular way?

JV-xgjk