|
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com