Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Sort
Hi Everyone:
I was wondering if any of the excel experts and MVP's know what algorithm excel is using for their sorting command (Data - Sort). I am trying to do something similar to Excel's sort that sorts column 1, then 2, then 3. All the algorithms that I have seen, only sort one column. Thanks for all your help. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Sort
AFAIK,
Excel sorts one column at a time from last to first. For example, if you select Col.s A first, then B second then C third, Excel sorts C then B then A. -- Hope this helps. Thanks in advance for your feedback. Gary Brown "Bob" wrote: Hi Everyone: I was wondering if any of the excel experts and MVP's know what algorithm excel is using for their sorting command (Data - Sort). I am trying to do something similar to Excel's sort that sorts column 1, then 2, then 3. All the algorithms that I have seen, only sort one column. Thanks for all your help. Bob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Sort
Don't know exactly what you want, but here is a site reference, and some of
the info that is on the site. http://office.microsoft.com/en-us/sh...ort %20orders Numbers Numbers are sorted from the smallest negative number to the largest positive number. Dates Dates are sorted from the earliest date to the latest date. Text Alphanumeric text is sorted left to right, character by character. For example, if a cell contains the text "A100," Excel Services places the cell after a cell that contains the entry "A1" and before a cell that contains the entry "A11." Text and text that includes numbers stored as text are sorted in the following order: 0 1 2 3 4 5 6 7 8 9 (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ ` { | } ~ + < = A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Apostrophes (') and hyphens (-) are ignored, with one exception: If two text strings are the same except for a hyphen, the text with the hyphen is sorted last. Note If you have changed the default sort order to be case-sensitive through the Sort Options dialog box in Microsoft Office Excel 2007, then the order for alphabetic characters is the following: a A b B c C d D e E f F g G h H i I j J k K l L m M n N o O p P q Q r R s S t T u U v V w W x X y Y z Z Logical In logical values, FALSE is placed before TRUE. Error All error values, such as #NUM! and #REF!, are equal. Blank cells In both an ascending and descending sort, blank cells are always placed last. Note A blank cell is an empty cell and is different from a cell with one or more space characters. Note Sort orders vary by locale setting. Excel Services sorts by the locale setting of the server, which may be different from your computer locale setting. For more information, see your administrator or Microsoft Office SharePoint Server Central Administration Help. "Bob" wrote: Hi Everyone: I was wondering if any of the excel experts and MVP's know what algorithm excel is using for their sorting command (Data - Sort). I am trying to do something similar to Excel's sort that sorts column 1, then 2, then 3. All the algorithms that I have seen, only sort one column. Thanks for all your help. Bob |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Sort
Why not just use the builtin sort? I presume you are doing in VBA, so just
code an Excel VBA sort. -- __________________________________ HTH Bob "Bob" wrote in message ... Hi Everyone: I was wondering if any of the excel experts and MVP's know what algorithm excel is using for their sorting command (Data - Sort). I am trying to do something similar to Excel's sort that sorts column 1, then 2, then 3. All the algorithms that I have seen, only sort one column. Thanks for all your help. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |