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