![]() ![]() Go to File > Options > Advanced > Edit custom list > Create new list > import priority order cells > Add list and click Ok. List your priority order in a different column. Go to Data > Sort > choose date column > Choose custom list Order by > select the recommended list (days of week or month of year) Excel also provides with its saved some list like days of week and months of year.Ĭhoose saved custom lists from Advanced sorting Like sorting delivery status of orders first delivered, pending and cancelled. Let's learn how to use a saved custom list in Excel.Ĭustom lists in excel are used to sort tables on the basis of given priority level. This is not at all the order of weekdays. You must be wondering by what happens when we sort days of week by A-Z or Z-A (standard sorting). For example sorting data based on days of week Sun, Mon, Tues, Wed, Thurs, Fri, Sat or sort table on month of year Jan, feb, Mar, apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec. Using a table with date values, the user faces problems when the data needs sorting on the basis of priority or given pattern. ![]() ![]() In this article, we will learn How to sort tables using the Custom list in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |