Filtering by Month
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 |
Filtering by Month
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 ToolsOptionsCustom Lists of Jan, Feb, etc. then in the PT, double click on the Months field and choose AdvancedAutosort optionsAscending then your months will be in correct date sequence. -- Regards Roger Govier "sandran" wrote in message ... 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 |
Filtering by Month
How about changing the data so that it says
01Jan 02Feb etc. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "sandran" wrote in message ... 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 |
Filtering by Month
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. sandran wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com