LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Custom Data Sort

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 the data column using my procedures and apply the sort to a range of
several columns.


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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort data on custom format shaji Excel Discussion (Misc queries) 3 September 18th 09 03:04 PM
Custom Sort of Filter? Steve B Excel Discussion (Misc queries) 5 December 3rd 08 08:29 PM
Custom Sort lincservices Excel Worksheet Functions 1 June 10th 08 05:06 PM
Custom Sort Steve Stanley Excel Discussion (Misc queries) 1 February 26th 07 09:39 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"