Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting a series of nos. on basis of digits
Dear All
Can anyone suggest me how do I sort a sequence of nos. on the basis of no. of digits.? For eg. I have a column with 9 digits and 10 digits nos. collectively. I wanna sort them on the basis of no. of digits. (i.e. 9 digits separately and 10 digits separately) How do I proceed further? Best Wishes Asad |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting a series of nos. on basis of digits
Select the column of numbers and pull-down:
Data Sort... Then select whether you want to sort ascending or descending. This works because numbers with more digits wil be larger than numbers with less digits. For example: 1 is less than 10 20 is less than 100 100 is less than 1000 1000 is less than 10000 -- Gary''s Student - gsnu200715 " wrote: Dear All Can anyone suggest me how do I sort a sequence of nos. on the basis of no. of digits.? For eg. I have a column with 9 digits and 10 digits nos. collectively. I wanna sort them on the basis of no. of digits. (i.e. 9 digits separately and 10 digits separately) How do I proceed further? Best Wishes Asad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting numbers with an irregular number of digits | Excel Discussion (Misc queries) | |||
How?-Sorting last digits and not the first | Excel Discussion (Misc queries) | |||
Keeping Chart Series Formats whilst sorting | Charts and Charting in Excel | |||
Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
Sorting data by last to digits | Excel Worksheet Functions |