Forum Discussion
Irregular Sorting in Excel
I am having a very strange issue. The SORT result of a Data Column in an Excel file is incorrect when I sort using my Windos Laptop. However, when I do the same sorting function from another computer ...
I tried Sorting thru the DATA, SORT option as well as using the SORT formula. Both give the same details from my Laptop.
The file is stored in OneDrive / Sharepoint.
The file is stored in OneDrive / Sharepoint.
Okay, let start from scratch.
- is another sorting order on your laptop for sorting numbers or texts or months or all of above?
- sorting could depend on locale (regional settings), are they the same for the laptop and another computer on which you tested?
- if copy the file from OneDrive to local folder (not synced with OneDrive) will you have the same sorting order as for the OneDrive file?
- what are regional settings for OneDrive?
But first question what is sorting incorrectly. E.g. 5,9,1 is sorted as 9,5,1 or doesn't sorted at all or what.