| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort order : Excel vs imported data
It would appear that the sort order of items returned via a Data Query is
different to that obtained following a sort within Excel. As an example, the imported list gives a sort order of FS-BZ followed by FSBM, whereas the Excel sort gives an order of FSBM followed by FS-BZ. Is there a global parameter that can be set to include, or not, characters such as "-" in the sort ? Or do I have to create a macro to ensure all data is sorted within Excel before doing a calculation. -- John Reynolds |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions | |||
| Can you sort text in a random order in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
