Sorting in Custom Alphabetical Order

[Raj]

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

 

[Chelsea]

Hi,u can define a customer lists with D,C,B,A
pathptions\advanced\edit customer list
or
enter new customer list when u choose sort with customer list

HTH
Chelsea

 

[Raj]

Hi,u can define a customer lists with D,C,B,A
pathptions\advanced\edit customer list
or
enter new customer list when u choose sort with customer list

HTH
Chelsea

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