Custom Sort in Excel - Text and Dates

In this video, we create a custom sort in Excel. Two custom sort examples are demonstrated - one with generic text and another with month names.

When sorting in Excel by numbers there is a natural sort order, but with text values, the only orders are A to Z or Z to A.

So, what if you want to sort text in the custom order of Max, High, Normal, and Low in that order. You will need to apply a custom sort in Excel, otherwise the values would appear in an order such as High, Low, Max, and Normal.

We will see how to custom sort in Excel with this example, and then a second example where we sort month names in the order of October to September. This is a popular request for users who work with financial years.

Learn more tips like this in 'Advanced Excel Success'
https://amzn.to/3nt5nqT

The timings of the video.
00:00 - Custom sort in Excel
00:39 - Custom sort text values
03:09 - Sorting in Excel by Custom List
04:02 - Create a custom sort for months

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!
LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Видео Custom Sort in Excel - Text and Dates канала Computergaga