Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Data Sort
"Jim" wrote in message news:... Hi: I need to sort several columns based upon a binary sort of a column of data. It will not sort binary on the worksheet. I have procedures that parse out the data character by character into arrays and sort it. My problem is that I don't know how to call the custom sort from a custom toolbar button. Unless Excel's Sort Method can do what I need it to do, I need to sort the data column using my procedures and apply the sort to a range of several columns. (Please disregard the formatting if it's messed up.) Befo After: (ie binary sort) a1000000 0000123 350a23.155 1 350a23.15 100 350a23.123 1000 350a23.11 1000000000001 350a23.101 11 350a23.100 111 350a23.10 1111 350a20.1555 12 1000000000001 14 0000123 2 1111 350a20.1555 1000 350a23.10 111 350a23.100 100 350a23.101 14 350a23.11 12 350a23.123 11 350a23.15 2 350a23.155 1 a1000000 Thanks in advance. Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Data Sort
Got it.
"Jim" wrote in message news:6%VTb.398998$ts4.360988@pd7tw3no... "Jim" wrote in message news:... Hi: I need to sort several columns based upon a binary sort of a column of data. It will not sort binary on the worksheet. I have procedures that parse out the data character by character into arrays and sort it. My problem is that I don't know how to call the custom sort from a custom toolbar button. Unless Excel's Sort Method can do what I need it to do, I need to sort the data column using my procedures and apply the sort to a range of several columns. (Please disregard the formatting if it's messed up.) Befo After: (ie binary sort) a1000000 0000123 350a23.155 1 350a23.15 100 350a23.123 1000 350a23.11 1000000000001 350a23.101 11 350a23.100 111 350a23.10 1111 350a20.1555 12 1000000000001 14 0000123 2 1111 350a20.1555 1000 350a23.10 111 350a23.100 100 350a23.101 14 350a23.11 12 350a23.123 11 350a23.15 2 350a23.155 1 a1000000 Thanks in advance. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort data on custom format | Excel Discussion (Misc queries) | |||
Custom Sort | Excel Worksheet Functions | |||
Custom Sort | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Custom Data Sort | Excel Programming |