Custom Sorting in Excel: sorting your data by season and by zodiac symbol
Let's go back to some basics. There's a lot of cool, brand new stuff in Excel. But I still see basic goofs committed by longtime professionals. Recently I saw a lot of graphs that showed values in the order:
1. Afternoon
2. Evening
3. Morning
4. Overnight
That alphabetical order makes no sense based on what we know about real life and how a day works. 😵💫
In this video, we're going to review Custom Sorting in Excel. Specifically:
Sorting students by season/session
Sorting your list of friends chronologically by their zodiac signs.
In this video I show you how to create a Custom List 2 ways:
1. the basic way in the Sort dialogue box and,
2. by importing a list that's too big to type.
Also! You get to see XLOOKUP used with icons as the lookup values. 🥳
#CustomSorting
#exceltutorial
#ExcelOnFire
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
My old blog: http://datascopic.net/blog-2-2