Jul 22 2021 04:17 PM
Jul 22 2021 11:23 PMSolution
@IsiI95 Your list contains texts that look like numbers. When you sort such a list, it is done in alphabetic order. And then, a text like "11" sorts before a text like "9" when you sort in ascending order. The opposite is true when you sort in descending order.
Rather than just pushing the Sort A to Z or Sort Z to A button, select "Custom Sort..."
Then choose your desired sorting options and press OK.
Now, Excel should warn you for the fact that you have texts in the list that look like numbers and give you two options. The following screen should pop-up.
Now you can fix your problem, but perhaps better to pay attention to making sure that your data is clean before you start manipulating it.