Secondary Sort by month

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

Bob Phillips

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)
 
Top