Forum Discussion
Excel - Sorting hierarchical numbers issue
SergeiBaklan The story is actually more complicated. You found 2808 unichars that appear to be completely ignored by comparators but the character "-" is only PARTIALLY ignored. Notice in the following sequence the values with _-173 use CHAR(173) while the _-4 values use a mix of "-" and CHAR(45) and additional numbers and "-" and variations. Notice how all the _-4x are sorted based on the number first and then all of the "-" give slight more value and bump those down (pay particular attention to 4, -4, 4-, -4- variations) but all the _-173 variations are in the same order as were found in the original list:
Yes, things are more complex and the logic behind is not clear, at least for me.
"10" is greater than "$10" as it shall be, at the same time against text comparing logic
"10" is greater than "€10"
"abc" is greater than "£abc"
UNICHAR(79) is greater than UNICHAR(8679)
etc...