We all know how to sort the data in Microsoft Excel. But few Excel experts don’t know how to sort the data by custom list.
In this tutorial, you will learn how we can create the custom list in Excel and then how we use it to sort the data.
What is Custom list?
Excel has frequently used sorting options, but Excel allows us to create the sorting list as per our requirement.
Let’s take an example and understand how we can make the custom sort list and how we can use it.
We have data in range A1:B24 in which column A contains Agents’ name and column B contains Revenue. In this data set, we want to put custom filter for the Agent name and then sort it.
To create the list, we retrieve the unique names:-
Follow below given steps:-
• Copy the names from list and paste in other column.
• Select the name range of column D.
• Go to Data Tab > Data tools > Remove duplicates
• We will have only unique list.
Note: – We can also use Advance filter option to retrieve the unique list.
How to store custom list?
• Click on Import, and all the entries will display in List Entries.
• Click on Add button, and then click on OK.
How to implement or use custom list in the sheet?
• Select one of the cells in the list.
• In the Data tab, select Sort, and ‘Sort Options’ dialog box will appear.
• Sort by Agent’s name in Column.
• In order, sort by Custom List.
• ‘Custom List’ dialog box will appear. Now, click the list of agent’s name, and then click on OK.
• Data will get sorted as per the custom list.
What we have learnt in this chapter:-
• What is Custom List
• How to create the custom list for sorting
• How we can apply the custom list for sorting
Conclusion: - Whenever we want to sort the data as per our requirement, we can create our own sorting list.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org