-----Original Message-----
Just curious to see if anyone knows what algorithms the
Excel programmers used to perform the sorting routines in
Excel.
Thanks
Mark
.
Well, I don't know for sure, but I would guess that they
use the same ones everyone else uses, converting the
characters to their character set numbers and sorting
them in numeric order by character set number if case
sensitive, or adding a constant like 32 to the upper case
numbers to make them equal to lower case numbers if not
case sensitive.
If you want to create a special sort order, choose Toolsorder. Then when you are ready to sort data, choose the
options button on the sort dialog box and select a custom
list as an alternate sort key order.
Bob Sullivan
