![]() ![]() Excel has a built-in list that we can use to sort that into recognizable order. On the left, you'll see that I have monthly inquiries for a particular company and the month names are sorted in ascending alphabetical order from A to Z and of course, that is different from the order that we have in our calendars. This workbook contains a single worksheet and on it I have two data lists. ![]() My sample file is the CustomSort workbook, and you can find it in the Chapter Two folder of the Exercise Files collection. I'll demonstrate how to use a built-in custom list and also create your own to perform custom sorts in this movie. But what if your data doesn't make sense when it's sorted into alphabetical order? In that case, you can identify a custom sort order. Most sorting operations arrange data into numerical or alphabetical order.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |