Want to sort a list of numbers by last two digit...

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I sort a list of numbers by the last 4 digits? 2
number digits 1-6 not sorting properly 2
Sorting 2
sort a cell by last two digits 4
Sort legal numbering 2
Custom Sort of Filter? 5
Sort by date month and not year 4
Number Sorting 2

Back
Top