Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting numbers the common sense way excell03
How do I get these rows sorted numerically
1705 17350 20028 20028 2053 220 3839 4077 4077 4646 4673 4673 as you can see it is sorting by the first digit without regard to its actual value. This is totally frustrating. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting numbers the common sense way excell03
Convert your data from text to numbers. You can do either:
a) Use a formula like this: =VALUE(A2) and sort by this, or do a Copy, Paste Special - Value b) Input 1 into a cell, copy it, then do a Paste Special - Multiply onto you data. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "dlaplant" wrote: How do I get these rows sorted numerically 1705 17350 20028 20028 2053 220 3839 4077 4077 4646 4673 4673 as you can see it is sorting by the first digit without regard to its actual value. This is totally frustrating. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting numbers the common sense way excell03
Hi,
convert text to numbers do Copy, paste special values "dlaplant" wrote: How do I get these rows sorted numerically 1705 17350 20028 20028 2053 220 3839 4077 4077 4646 4673 4673 as you can see it is sorting by the first digit without regard to its actual value. This is totally frustrating. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting numbers the common sense way excell03
A real solution to this is:
put this formula beside the data, and drag it: =len(A1) for instance. in column B, then select both columns, and sort by column B. That's it. -- Alex *Remember to click "yes" if this post helped you. Thank you! "dlaplant" wrote: How do I get these rows sorted numerically 1705 17350 20028 20028 2053 220 3839 4077 4077 4646 4673 4673 as you can see it is sorting by the first digit without regard to its actual value. This is totally frustrating. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting numbers the common sense way excell03
Actually you should sort first by column B then by column A (your data in
column A) -- Alex *Remember to click "yes" if this post helped you. Thank you! "alexrs2k" wrote: A real solution to this is: put this formula beside the data, and drag it: =len(A1) for instance. in column B, then select both columns, and sort by column B. That's it. -- Alex *Remember to click "yes" if this post helped you. Thank you! "dlaplant" wrote: How do I get these rows sorted numerically 1705 17350 20028 20028 2053 220 3839 4077 4077 4646 4673 4673 as you can see it is sorting by the first digit without regard to its actual value. This is totally frustrating. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMMON NUMBERS | Excel Worksheet Functions | |||
Random Numbers with certain numbers more common than others | Excel Worksheet Functions | |||
Linear Trendline Vs Common Sense | Charts and Charting in Excel | |||
I still cant get the six most common numbers to come up | Excel Discussion (Misc queries) | |||
Removing blanks / sorting - common methods not applicable | Excel Discussion (Misc queries) |