sort by month out of sequence

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
 
M

Mike H

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
 
D

David Biddulph

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

Cam

Actually I forgot to mention. The date is calculated from Access and imported
from Access DB through pivot table.
 
D

David Biddulph

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?
 
Top