Sorting differences on PC vs Mac
Hello, I am having an issue with sorting. I am on Mac and my colleague is on PC. We have a file with product names that is being sorted differently on the two devices in Excel. On Mac it is...
Forum Discussion
happylinenco Ah, I see. Get the same result and can't explain why. The "-023" should not affect that.
WB-H consists of character codes 87, 66, 45 and 72 (both on Mac an PC)
WBC- consists of character codes 87, 66, 67 and 45 (both on Mac an PC)
When sorting, WB-H should become before WBC-, just like the Mac does it. On my PC it gets sorted incorrectly. Haven't been a PC user very long, and never came across (or noticed) this issue. Looks like a bug in the PC version.
Riny_van_Eekelen thanks for trying and confirming it's not just us ha!
We have been able to narrow it done, like you, to what comes after WB- or WBC- respectively. If the following letter is either A or B (i.e. above C in the alphabet) it works fine. Letters lower in the alphabet (D onwards) the sorting is incorrect.
Very strange!
Anybody has come across this issue before that can assist?
We have been able to narrow it done, like you, to what comes after WB- or WBC- respectively. If the following letter is either A or B (i.e. above C in the alphabet) it works fine. Letters lower in the alphabet (D onwards) the sorting is incorrect.
Very strange!
Anybody has come across this issue before that can assist?
- what about the - earlier in the name comparing
CASTLEUNICORN- vs
CASTLEUNICO-
according to your logic that R is after B so should also cause sorting issue?
