Forum Discussion
Irregular Sorting in Excel
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?
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.So, do I understand correctly that's only for one concrete workbook, and perhaps only for one worksheet in this workbook? And if you sort exactly the same file (not copy/pasted data) on iPad it sorts it in a right way?