Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to sort a list of numbers by last two digit...
Hi,
I have a long list of numbers ie 1.2003 to 7.2007 that are not in order how can I sort them so I get them in month and year order. When I do a sort know I get them in Month and year order ie 1.2003 2.2004 3.2005 and not 1.2003 2.2003 1.2004 2.2004 Cheers Paul. Paul. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to sort a list of numbers by last two digit...
You'll have to use 2 helper columns to separate the data into month and year - (using text formulas like FIND and LEFT and RIGHT). Then you can sort data based on two columns - year first then month second. "Paul" wrote: Hi, I have a long list of numbers ie 1.2003 to 7.2007 that are not in order how can I sort them so I get them in month and year order. When I do a sort know I get them in Month and year order ie 1.2003 2.2004 3.2005 and not 1.2003 2.2003 1.2004 2.2004 Cheers Paul. Paul. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to sort a list of numbers by last two digit...
You could do a find and replace the . with / and then format the column into
mm/yyyy that would do the trick. Paul wrote: Hi, I have a long list of numbers ie 1.2003 to 7.2007 that are not in order how can I sort them so I get them in month and year order. When I do a sort know I get them in Month and year order ie 1.2003 2.2004 3.2005 and not 1.2003 2.2003 1.2004 2.2004 Cheers Paul. Paul. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering 16 digit numbers - last digit turns to zero | New Users to Excel | |||
List Sorts Numbers By First Digit, Rather Than The Whole Number. | Excel Discussion (Misc queries) | |||
sort numbers based on initial digit. | Excel Discussion (Misc queries) | |||
I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel |