Sort by Month in Excel? Here's the Secret Custom Sort Trick! (Windows + Mac)
Have you ever tried to Sort by Month in Excel?
It comes as a surprise, but Excel cannot do that unless you provide it with a very specific input.
Custom Sort help you sort data on months, days of the week and that too when represented in different formats.
You can also create your own custom lists and use them for sorting on criteria, which may be relevant for your purpose, such as project tracking, stages, levels, etc.
🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introduction
00:24 - The challenge with sorting data on months
00:58 - Sorting on months using custom list
01:29 - Creating your own custom list
02:49 - Creating custom lists in a Mac machine
▶️ Other videos that may interest you
How to SORT data on single & multiple criteria in Excel? (Covers SORT & SORTBY functions)
• How to SORT data on single & multiple crit...
✅ Subscribe to our Channel to level up your Excel skills faster
/ @analyticssuccess
⬇️ Download the file used in the video
https://www.qling.net/11174/files/66c...
💻 Courses offered by us
Learn more about our Excel Masterclass course
https://yt.qling.net/excel-masterclass
Explore all courses
https://yt.qling.net/courses
📘 Download our E-Book on Excel Shortcuts (Windows and Mac)
https://yt.qling.net/excel-shortcuts
🗂️ Access all our templates and E-Books
https://yt.qling.net/templates-and-eb...
🤝 Connect with us
LinkedIn: / qling1
Facebook: / learnatqling
Instagram: / learnwithqling
Pinterest: / learnatqling
Get in touch: https://quiz.qling.net/get-in-touch/
#analyticssuccess, #CustomSort, #ExcelTips, #ExcelTutorial, #ProductivityHacks, #MicrosoftExcel, #ExcelForBeginners, #SpreadsheetSkills, #WindowsAndMac