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.
|