ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sorting in Custom Alphabetical Order (https://www.excelbanter.com/excel-worksheet-functions/255313-sorting-custom-alphabetical-order.html)

Raj[_2_]

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

Chelsea[_2_]

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



Raj[_2_]

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



All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com