M
mudman
I have about 2000 rows and 2 columns of float data, pasted in as values. If i
select both columns, and sort the first ascending, followed by the second
ascending (i know there are duplicates in the first column), Excel 2002 does
not always sort the data in this second column correctly. i.e. sometimes a
small value appears at the end of the sub-list. The same (albeit in reverse),
happens if i sort the second column descending, although strangely, not
always the same cells are impacted. I think it is an internal rounding error,
as if i simulate it in VBA, i get a similar issue. I'd appreciate any
thoughts.
select both columns, and sort the first ascending, followed by the second
ascending (i know there are duplicates in the first column), Excel 2002 does
not always sort the data in this second column correctly. i.e. sometimes a
small value appears at the end of the sub-list. The same (albeit in reverse),
happens if i sort the second column descending, although strangely, not
always the same cells are impacted. I think it is an internal rounding error,
as if i simulate it in VBA, i get a similar issue. I'd appreciate any
thoughts.