Learn how to create and use custom lists to sort data in Excel by your own order. Custom lists let you define and apply your own sorting criteria.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to master custom sorting in Excel with SORTBY, LET, and XMATCH. Organize data dynamically and save time with advanced techniques.

We show you how to put data in alphabetical order in Excel, sorting columns, rows, and using handy shortcuts.

Excel Ribbons may vary depending upon your version, buts its good to sort them This Tip is written in Office 2016 so images of tools or ribbons may differ from your version. The features still work ...

Sorting out a filtered list My students are great because they always pose questions on my courses. One that most commonly crops up is the one where they need to know if once they have filtered their ...

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

If you do so, it will arrange the entire data in alphabetical order (from Z to A or from A to Z). In this case, you can use other methods to arrange a list in Excel in reverse order.