Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in Custom Alphabetical Order
Hi,
I need to sort a list of names in a different alphatecal order eg. D,C,A,B. The Custom sorting in Excel works if I make a custom list of complete strings eg. North, East, West, South. Is there any way I can do this? Thanks in advance for the help. Regards, Raj |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in Custom Alphabetical Order
Hi,u can define a customer lists with D,C,B,A
path:options\advanced\edit customer list or enter new customer list when u choose sort with customer list HTH Chelsea "Raj" wrote in message ... Hi, I need to sort a list of names in a different alphatecal order eg. D,C,A,B. The Custom sorting in Excel works if I make a custom list of complete strings eg. North, East, West, South. Is there any way I can do this? Thanks in advance for the help. Regards, Raj |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in Custom Alphabetical Order
On Feb 4, 8:41*am, "Chelsea" wrote:
Hi,u can define a customer lists with D,C,B,A path:options\advanced\edit customer list or enter new customer list when u choose sort with customer list HTH Chelsea "Raj" wrote in message ... Hi, I need to sort a list of names in a different alphatecal order eg. D,C,A,B. The Custom sorting in Excel works if I make a custom list of complete strings eg. North, East, West, South. Is there any way I can do this? Thanks in advance for the help. Regards, Raj Hi, The data is to be sorted as under (these are just sample values, more B's and A's will get added): Black Brown Andrade Angelina (ie all the B's followed by all the A's and so on.) How to make a custom list for this? Regards, Raj Raj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
last name alphabetical order | Excel Discussion (Misc queries) | |||
Create a custom fill series or sorting order | Excel Worksheet Functions | |||
Sorting Cells in Alphabetical Order by Last Name | Excel Discussion (Misc queries) | |||
Alphabetical order possible? or not | Excel Discussion (Misc queries) | |||
sorting letters in words into alphabetical order | Excel Discussion (Misc queries) |