Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Sorting in Excel 2003


  • Please log in to reply

#1
diggeryo

diggeryo

    Member

  • Member
  • PipPipPip
  • 343 posts
I have a long list of things with one column containing dates in the format: January 01, 2001.

I'd like to sort by the date column by Month and Date, with January 01 being the first row and December 31 being the last row, regardless of year. However, everytime I sort, it sorts it by year. Even when I followed the help offered in Excel itself, where it told me to click "options" under sort and choose the month option, it still sorted by year.

Any help would be appreicated.

thanks,
mike.
  • 0

Advertisements


#2
Dockboy

Dockboy

    Member

  • Member
  • PipPip
  • 79 posts
Hi Mike...again,

How are your columns formatted?

Is it like this?

Date Data Data 2 Data 3

Or like this?

Day Month Year Data


Let me know.


Cheers:)
  • 0

#3
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
I have one column with the entire date in it (in the following format: January 01, 2001).

I wanted to sort it so all the months would be clumbed together in order regardless of the year but couldn't seem to get it to sort properly when sorting by the column that had the date in it.

I figured a workaround for it, though. I created an additional column and put in the formula "=MONTH(B1)" so that this additional column would show the number for the month (January=01, February=02, etc.). I then sorted by this additional column.

It got the result of was looking for, but there has to be an easier way to do it.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP