sort by month out of sequence

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

?ello,

I have column by month in this format: yy-mmm (08-Mar, 08-Apr, etc). But
when I sort the column it is not in the order of Jan to Dec instead by the
first letter of the month. Is there a way to sort it so it recognize the
month instead. Thanks
 
Hi,

Maybe this. With your dates in A1 down put this in B1
=Month(a1)
drag down as required and select both columns A & B and sort on B
You can then hide B if you want.

Mike
 
It sounds as if you have entered the data as text, rather than as dates
appropriately formatted. If you put them in as dates they will sort
successfully.
You can check by using =ISTEXT and =ISNUMBER. If they are real dates,
=ISNUMBER will be TRUE.
 
Actually I forgot to mention. The date is calculated from Access and imported
from Access DB through pivot table.
 
Surely that would work only if column A contained dates, and if it did then
A should already sort OK? If A doesn't sort correctly, it is presumably
text?
 

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

Sorting dates in the format Jan Feb Mar Apr ... ??? 4
Pivot table 3
Excel 2002: Why I could not sort month/year text now ? 1
dates of month automation 3
Average of 12 months data from a specific month 2
Finding a sum by matching two cells with the same identifier 1
Month question? 10
Sum Totaled based on Matching Identical Criteria in Worksheet 1

Back
Top