sorting by series

[Tom James]

Is there a quick way I can sort a worksheet by a series like Mon thru Fri or
Jan thru Dec instead of alphabetically? I want to sort a data list that
contains days of the week from Mon thru Sat and then subtotal them.

Thanks,

Tom

 

[Trevor Shuttleworth]

Tom

in the sort dialogue box, choose Options and pick the one you need. You can
also define a Custom Sort Order

Regards

Trevor

 

[Tom James]

Thanks, Trevor! I should have found that one myself!