Sorting: Sorting by months or days of the week, in date order instead of alphabetical order

All right. It's time to do some really advanced sorting.

Let's say you have a schedule and you want to sort it by day of the week. What's the first day of the week? Monday. But alphabetically it's not first. Friday, for instance, comes before Monday. So here's how to sort by days of the week, months, etc.

You've got your data.

Select it and choose Data > Sort.

Click the Options tab and make the appropriate selection for Range Contains Column Labels.

Now select Custom Sort Order and select the one you want.

Click the Sort Criteria tab and select the column to sort by that contains the corresponding kind of data.

Click OK.

And you get your results.

Wondering "Where did that sort order come from?"

Wondering "Could I perhaps make my own sort order, like President Vice-President Secretary Treasurer or High Card, Pair, Two Pair, Trips, and so on?"

You will have your questios answered in the next installment of Sorting.

---

---

Comments

[Heike]

Hi,
I got a problem with sorting columns alphabetically. Which means:
There are columns like
a_column - c_column - b_column - f_column
1 - 3 - 4 - 7
2 - - 5 -
- - 6 -
(with each more data beneath it)
I want to sort all colums alphabetically, including the data beneath.

For the example the result should be:
a_column - b_column - c_column - f_column
1 - 4 - 3 - 7
2 - 5 - -
- 6 - -

Is there any posibillity to sort that way?
Thanks for your help in advance!