Forum Discussion
Excel bug Data sorting largest to smallest
Odd indeed, but it's due to some minute rounding difference. The first 593.1 is considered greater than the second one. Normally you would see that in the 15th decimal but in your file that's not the case either. Both numbers are equal to the eye, though internally they are not. Google for "floating-point arithmetic" to read more about it.
When you notice something like that, wrap your formulas in column M in the ROUND function and the problem will go away. In M5 enter:
=ROUND(SUM(G5:L5),1)and copy down. Re-apply the custom sort.
I don't know why you get those results. With my formula, I get these results like in the image.
I have apply my formula in cell O5.
If to check xml, values kept are
and
With that it doesn't matter how to sort, value in M43 is greater than one in M44. Your formula gives for me
I also have no idea why do we have different results. Perhaps we are on different Excels. I'm on
This is my version of ExcelOn Beta, same build, nothing changes for me