Sort Feature Acting Wonky

sacajamo

New Member
Joined
May 9, 2007
Messages
22
Office Version
  1. 365
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:


6013.136114.16114.826008.56-3.42
6117.526134.56134.56084.59-9.65
6144.156117.766147.436111.15-11.82
6129.586121.66129.636099.516.97
6114.636115.526127.476107.620.45
6115.076060.596116.916050.958.62
6051.976025.0860636003-43.42
6068.56049.326076.286042.34-17.12
6066.446046.46073.386044.8420.41

Here is what it looks like after sorting by the far right column smallest to largest, making sure I "expand the selection:


6051.976025.0860636003-43.42
6068.56049.326076.286042.34-94.83
6144.156117.766147.436111.150.24
6117.526134.56134.56084.59121.37
6013.136114.16114.826008.56-0.53
6114.636115.526127.476107.62-14.06
6129.586121.66129.636099.516.53
6115.076060.596116.916050.95-5.85
6066.446046.46073.386044.8420.41

What am I doing wrong?
 
Formulas shouldn't be a problem as long as they don't include the name of the sheet they are on.
 
Upvote 0
Yeah, it all depends on how the formula is written.
If you write it a certain way, it may be returning a text value instead of a numeric one (like if you are using STRING functions on it).
As long as the value you are returning is totally numeric, you can usually convert it back to a number by doing something like adding 0 to the end of the formula, i.e.
Rich (BB code):
= current formula + 0
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top