Sort Data as per your own Custom list in Excel in Hindi
You can use a custom list to sort in a user-defined order. Excel provides built-in, day-of-the-week and month-of-the year custom lists, and you can also create your own custom list.
Optionally, create the custom list.
In a range of cells, enter the values that you want to sort by, in the order that you want them, from top to bottom.
- You can only create a custom list based on a value (text, number, and date or time). You cannot create a custom list based on a format (cell color, font color, and icon).
- The maximum length for a custom list is 255 characters, and the first character must not begin with a number.