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 (or by another User on his computer), the data sorts correctly.I have tried copying the data (paste values only) into a new file but the results are still the same.

Paul_Castelino 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.

Paul_Castelino 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.

Paul_Castelino 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?

Irregular Sorting in Excel | Microsoft Community Hub

19 Replies

Lewis-H
Iron Contributor
May 01, 2020
Select one cell in the column you want to sort.
Press Ctrl + A, to select the entire region.
Check the selected area, to make sure that all the data is included.
On the Excel Ribbon, click the Home tab.
In the Editing group, click the arrow on Sort & Filter.
Click Custom Order.
- Paul_Castelino
  Copper Contributor
  May 01, 2020
  Data is in a Table format so the Sorting steps are correct. The issue is that ot does not sort in correct order from my Laptop but the same file sorts correctly from other devices.
  - SergeiBaklan
    Diamond Contributor
    May 01, 2020
    Paul_Castelino
    
    If your laptop is on Windows did you have a chance to test on another Windows machine? Or perhaps you could submit the file in question here to remove sensitive information.
SergeiBaklan
Diamond Contributor
May 01, 2020
Paul_Castelino

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?
- Paul_Castelino
  Copper Contributor
  May 01, 2020
  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.
  - SergeiBaklan
    Diamond Contributor
    May 01, 2020
    Paul_Castelino
    
    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.

Forum Discussion

Irregular Sorting in Excel

19 Replies

Resources