Excel for Mac: How to Create Custom Lists for Sorting

Опубликовано: 16 Июнь 2024
на канале: Mike Thomas
1,031
28

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


Смотрите видео Excel for Mac: How to Create Custom Lists for Sorting онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mike Thomas 16 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,03 раз и оно понравилось 2 людям.