Sort Number & Data Large to Small & Ascending to Descending in Microsoft Excel.. Facebook Page : / memjtube Follow on twitter: / mj1111983 Website : www.bsocialshine.com
This work only when your figures have the same number of digits but if you mix 2, 3 , 4and 5 digit numbers it doesn't work. Excel arrange figures by decade, hundreds thousands etc...
We are trying to sort rows in numerical order (we have about 70 rows with these type numbers below). We know that's doable in numerical order, however, the numbers are unusual. Her is an example of a column and each number is in a row: 2-6-0 2-10-2 2-6-2 4-8-2 4-4-2 2-8-2 2-8-4 2-6-4 2-8-0 0-6-0 2-10-0 The problem: The focus is on getting the middle number(s) all grouped together and then sorted in order with the first digit (and last digit) then being numerically sorted. We are trying to sort them like this in the column as an example: 4-4-2 0-6-0 2-6-0 2-6-2 2-6-4 2-8-0 2-8-2 2-8-4 4-8-2 2-10-0 2-10-2 Normal numerical sorting would not group these correctly like shown because it would use the first number as the sorting point.These numbers by the way are railroad steam engine designations for their wheel arrangements, for which I have about 70 vintage brass models of these in HO scale and I need to sort them correctly to find them easily on a spread sheet. There are 12 columns in our spread sheet (one column with the numbers above) and the other columns with other data like: manufacturer, whether factory painted, condition, w/original box, etc). Thanks and hoping there is a way to sort them. Thanks. Philip