Forum Discussion

Copper Contributor

Jul 21, 2022

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

Copper Contributor

Jul 21, 2022

It seems to be a Mac vs PC issue as I have managed to test on other Mac and PC devices. All of them seem to sort it differently. On all Macs, WB comes first. On all PCs, WBC comes first.

Riny_van_Eekelen
Platinum Contributor
Jul 21, 2022
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.
- happylinenco
  Copper Contributor
  Jul 21, 2022
  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
  - Riny_van_Eekelen
    Platinum Contributor
    Jul 21, 2022
    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.

Share

Resources