Make sure your list is in the same order in which you want the data to be sorted. Step 5: Under List entries, type the values you want the custom list to contain. So add a fresh list, the one that you need, here. It is likely that you do not already have a custom list added if you have never used it before. Step 4: After you click on OK you will be presented with a window named Custom Lists. Drop down the Sort by column (here I selected Department), select Values under Sort On and Custom List for Order. Step 3: That will launch the Sort dialog window. Step 2: Once you have the data selected, head over to the ribbon and switch to the Data tab. For me it was the data shown in the sample. Step 1: Select the data range that you wish to sort. Read our guide to better understand and learn how to use it. Here’s how you can use the feature and apply custom sorting on MS Excel.Ĭool Tip: Another powerful MS Excel data feature is the Filter option. And hence, I could deliver the results with very little effort and in very little time. Thankfully I use MS Excel for working with data sets. Instead, he wanted the data to be sorted in the following order. His requirement was neither ascending nor descending. My boss asked me to sort the data by Department.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |