I have a set of historical stock data that I want to sort smallest to largest using column "E", but row data needs to stay the same. Here is what it looks like before sorting:
Here is what it looks like after sorting by the far right column smallest to largest, making sure I "expand the selection:
What am I doing wrong?
6013.13 | 6114.1 | 6114.82 | 6008.56 | -3.42 |
6117.52 | 6134.5 | 6134.5 | 6084.59 | -9.65 |
6144.15 | 6117.76 | 6147.43 | 6111.15 | -11.82 |
6129.58 | 6121.6 | 6129.63 | 6099.51 | 6.97 |
6114.63 | 6115.52 | 6127.47 | 6107.62 | 0.45 |
6115.07 | 6060.59 | 6116.91 | 6050.95 | 8.62 |
6051.97 | 6025.08 | 6063 | 6003 | -43.42 |
6068.5 | 6049.32 | 6076.28 | 6042.34 | -17.12 |
6066.44 | 6046.4 | 6073.38 | 6044.84 | 20.41 |
Here is what it looks like after sorting by the far right column smallest to largest, making sure I "expand the selection:
6051.97 | 6025.08 | 6063 | 6003 | -43.42 |
6068.5 | 6049.32 | 6076.28 | 6042.34 | -94.83 |
6144.15 | 6117.76 | 6147.43 | 6111.15 | 0.24 |
6117.52 | 6134.5 | 6134.5 | 6084.59 | 121.37 |
6013.13 | 6114.1 | 6114.82 | 6008.56 | -0.53 |
6114.63 | 6115.52 | 6127.47 | 6107.62 | -14.06 |
6129.58 | 6121.6 | 6129.63 | 6099.51 | 6.53 |
6115.07 | 6060.59 | 6116.91 | 6050.95 | -5.85 |
6066.44 | 6046.4 | 6073.38 | 6044.84 | 20.41 |
What am I doing wrong?