sort by month out of sequence
 

?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

sort by month out of sequence
 

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

"Cam" wrote:

?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

sort by month out of sequence
 

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.
--
David Biddulph

"Cam" wrote in message
...
?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

sort by month out of sequence
 

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

"Mike H" wrote:

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

"Cam" wrote:

?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

sort by month out of sequence
 

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?
--
David Biddulph

"Mike H" wrote in message
...
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

"Cam" wrote:

?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