Hello all,
I tried my usual googling, but I just can't figure this out. I have a series of numbers that I'm trying to sort, but everytime I do it gives me a totally nonsensical order.
It's part of a Table, and the values are produced by a simple formula =F#-L#. I'm not sure if either of those are contributing factors.
Just to show what it is going on below is the order the numbers appear on my table on the left, and the right is the order the appear after sorting large to small. (I don't think the actual order is important, just illustrating how mixed up it is)
<colgroup><col span="2"></colgroup><tbody>
</tbody>
I also checked the other columns, to see if for some reason one of them was being put in order instead, but that's not the case.
Any insight as to what I might have overlooked in why this won't sort?
Currently it's only 28 items, but it will be expanded to 200+ so I'd like to nip this in the bud before it mucks up everything.
Thanks
I tried my usual googling, but I just can't figure this out. I have a series of numbers that I'm trying to sort, but everytime I do it gives me a totally nonsensical order.
It's part of a Table, and the values are produced by a simple formula =F#-L#. I'm not sure if either of those are contributing factors.
Just to show what it is going on below is the order the numbers appear on my table on the left, and the right is the order the appear after sorting large to small. (I don't think the actual order is important, just illustrating how mixed up it is)
6.19 | 6.25 |
6.88 | 6.91 |
4.65 | 4.69 |
11.46 | 11.42 |
5.76 | 5.76 |
7.13 | 7.19 |
7.11 | 7.27 |
2.48 | 2.29 |
2.47 | 2.24 |
4.08 | 4.34 |
11.48 | 11.53 |
9.78 | 10.04 |
2.83 | 2.65 |
2.83 | 2.65 |
8.22 | 8.03 |
8.05 | 8.01 |
5.91 | 5.73 |
6.43 | 6.37 |
3.57 | 3.62 |
28.97 | 28.91 |
33 | 32.98 |
5.13 | 5 |
25.79 | 25.8 |
26.02 | 26.08 |
8.37 | 8.33 |
21.21 | 21.4 |
20.41 | 20.53 |
6.2 | 6.39 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
I also checked the other columns, to see if for some reason one of them was being put in order instead, but that's not the case.
Any insight as to what I might have overlooked in why this won't sort?
Currently it's only 28 items, but it will be expanded to 200+ so I'd like to nip this in the bud before it mucks up everything.
Thanks