Excel for Mac: How to Create Custom Lists for Sorting
Excel's built-in lists let you sort your data by day name or month name. But you can also build your own custom lists to sort your data based on an order of your choosing.
For example I need to sort a list of sales transactions based on location, not A-Z but based on the following order...Los Angeles, Seattle, Delaware, Boston, New York. This is where a custom list is needed.
Although you can create a custom list in Excel on the Mac, the process differs to how you do it in Excel for Windows.
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/vqflwdw5jwz7cqu...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #mac #sort #customlist