Filtering by Month

[Guest]

I'm having a problem with filtering by abbreviated months in Excel.

For example, I will have a list of cells with the month:

Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

When turning autofilter on, it will give me the list in alphabetical order,
instead of Monthly Order. This becomes very inconvenient, when I have a Pivot
Table, where one of my data fields is by month, and won't sort them in the
sequetional months.
It has worked in the past, but now, when I re-opened the spreadsheet, this
happens.
I've tried making a new spreadsheet, changing the format, using the month
function, and nothing works, could you please help me.

Thanks,

sandran

 

[Roger Govier]

Hi

Can't help with Autofilter, as it defaults to alphabetic order.
In the Pivot Table however, if you have a list of months set up in
Tools>Options>Custom Lists
of Jan, Feb, etc.
then in the PT, double click on the Months field and choose
Advanced>Autosort options>Ascending
then your months will be in correct date sequence.

 

[Bob Phillips]

How about changing the data so that it says

01Jan
02Feb

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Dave Peterson]

You could convert the data to real dates and just format them to show the
abbreviated month name. It might even be useful when you go into the next year.