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 ...
Do you have the same result if you sort manually, not by function? If so, do you have the same locale as on other 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.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.
- Hi. Does Regional Sertings really effect sorting of TEXT? My Data instead of sorting from 1-9 and then A-Z is sorting randomly (only on my computer). The order is not making sense. And as I mentioned if I use my iPad to sort the same data, it sorts in correct order i.e. 1-9 and A-Z.
Other files on my Laptop are sorting in correct order, so dont think it's a Regional Sorting Issue.
Also moved the file from OneDrive to my local drive, but the sorting is still irregular.
