Filtering by Month


G

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
 
Ad

Advertisements

R

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

Bob Phillips

How about changing the data so that it says

01Jan
02Feb

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Ad

Advertisements

D

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.
 

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

Top