Custom sorting

[mvasanth]

Hi,

I want to sort in the following way:

DMA
DMB
MWB
01A
10B
45B
45O
450
451
459

.. list continues for n number of 3-characters combinations.

Problems I have are:
1. The custom list has only 254 lists.... I have more than 30000+ lines
2. My rule is: A-Z, 0-9.
3. I am not able to change the default excel sort...

Can anyone help me.

Thanks
Vasanth

[David McRitchie]

As long as you are not looking to sort numerically the following
will allow you to approximate an EBCDIC (mainframe) type of sorting.

Sorting, Some notes on sorting in Excel
Sorting as if EBCDIC as on a mainframe (#ebcdic)
http://www.mvps.org/dmcritchie/excel/sorting.htm#ebcdic
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mvasanth" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
>
> I want to sort in the following way:
>
> DMA
> DMB
> MWB
> 01A
> 10B
> 45B
> 45O
> 450
> 451
> 459
>
> . list continues for n number of 3-characters combinations.
>
> Problems I have are:
> 1. The custom list has only 254 lists.... I have more than 30000+
> lines
> 2. My rule is: A-Z, 0-9.
> 3. I am not able to change the default excel sort...
>
> Can anyone help me.
>
> Thanks
> Vasanth
>
>
> --
> mvasanth
> ------------------------------------------------------------------------
> mvasanth's Profile: http://www.excelforum.com/member.php...o&userid=26753
> View this thread: http://www.excelforum.com/showthread...hreadid=400069
>

[mvasanth]

Thank you.

I am not clear with the page you had give.

1. I am looking for altering the standard sorting feature of excel.

ELSE

2. A macro that does the sort function in my style.

I think this Mainframe style is what I require, but could not do with the function you gave.

Thanks
Vasanth

[David McRitchie]

There should be a link to the page
Getting started with macros and user defined functions.
http://www.mvps.org/dmcritchie/excel/getstarted.htm

You have to sort on the column with data that looks like garbage.

So what happened instead of it working.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mvasanth" <[email protected]> wrote in message
news:[email protected]...
>
> Thank you.
>
> I am not clear with the page you had give.
>
> 1. I am looking for altering the standard sorting feature of excel.
>
> ELSE
>
> 2. A macro that does the sort function in my style.
>
> I think this Mainframe style is what I require, but could not do with
> the function you gave.
>
> Thanks
> Vasanth
>
>
> --
> mvasanth
> ------------------------------------------------------------------------
> mvasanth's Profile: http://www.excelforum.com/member.php...o&userid=26753
> View this thread: http://www.excelforum.com/showthread...hreadid=400069
>