Jul 21 2022 03:14 AM
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 sorted like so:
A-PIL
A-QTH
A-WB
A-WBC
A-Z
On PC it is sorted like so:
A-PIL
A-QTH
A-WBC
A-WB
A-Z
Basically, the WBC and WB is flipped on the two devices. On Mac it thinks that WB comes higher in the alphabet than WBC and on the PC it is vice-versa. This is causing huge issues for us.
I have not been able to find this issue elsewhere on the web sadly. I am unable to tell if this is a Mac vs. PC issue or isolated to my colleague's device, i.e. a system setting that is changing the sorting priority for characters.
Any ideas?
Jul 21 2022 03:19 AM
Jul 21 2022 03:40 AM
@happylinenco Both my Mac and PC sort these text exactly the same, namely how you mentioned it in your example for the Mac. "A-WB" sorts before "A-WBC" as it should.
Jul 21 2022 03:46 AM - edited Jul 21 2022 03:53 AM
@Riny_van_Eekelen
Please could you try the following in that case. I can see the A- example is working correctly, so maybe this wasn't the best example. Below is the actual product names which are being sorted differently. The WB and WBC versions are being sorted differently on PC and Mac.
CASTLEUNICO-PNK-PIL-HL01-STD
CASTLEUNICO-PNK-QTH-HL01-ONE
CASTLEUNICO-PNK-STI-HL01-5025
CASTLEUNICO-PNK-WBC-HL01-90120
CASTLEUNICO-PNK-WB-HL01-90120-23
CASTLEUNICORN-PNK-PJS-HL02-34
CASTLEUNICORN-PNK-PJS-HL03-45
Jul 21 2022 04:23 AM - edited Jul 21 2022 04:23 AM
@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.
Jul 21 2022 04:35 AM
Jul 21 2022 04:49 AM
Jul 21 2022 07:36 AM