Secondary Sort by month

  • Thread starter Thread starter Tanya
  • Start date Start date
T

Tanya

I have a worksheet that I need to sort by department name and then
month, which appears as January, February, etc. However the option to
sort by month in proper chronological order doesn't seem to be
available unless the month is the primary sort key. How can I use month
name as the secondary sort key. Thanks,
 
Add a helper column to get the month number and sort on that

=MONTH(--("01-"&B1&Year(TODAY()))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

sort a column by date- by month not year 5
Excel 2007: Weird Pivot Table Sorting Problem 1
Report by Month Sorting Issue 5
Sort Dates by Month and Day, Not Year 4
Sorting dates in Excel 13
days of the current month 2
date format 2
sort by date ? 3

Back
Top