Introduction
Excel custom lists are an excellent way to manage and sort data that follows a specific pattern. In this article, we will guide you through the process of correctly sorting an Excel custom list. We will use the example of a list with the following entries and values: Pu, Tsu, ʢu, Wu, Bi, Tzi, Ri, Yi, Mo, Ta, Za, Rra, ɲa.
Step 1: Ensure Your Data is in a Custom List
Before you can sort your data, make sure it is in an Excel custom list. To create a custom list, select the range of cells containing your data, go to the "Data" tab, and click "New Custom List." Enter the values in the order you want them sorted, and click "Add."
Step 2: Check Your List is Properly Formatted
Excel custom lists can only be sorted if they are properly formatted. Check that your list has no blank cells, and all text is in the same case (upper or lower). In our example, all values are in lowercase.
Step 3: Sort Your Custom List
To sort your custom list, go to the "Data" tab, click "Sort," and select the column containing your custom list. Choose the "Custom List" option under "Sort On," and then click "OK."
Step 4: Verify Your List is Sorted Correctly
Excel should now have sorted your custom list correctly. Double-check the results by comparing them to the expected order: Bi, Mo, Pu, Ri, Ta, Tsu, Tzi, ʢu, Wu, Yi, Za, Zi, Rra, ɲa.
In this article, we showed you how to correctly sort an Excel custom list using a step-by-step guide. By ensuring your data is in a custom list, properly formatted, and then sorting it, you can efficiently manage your data and maintain its order.