Problem: I have a column with values such as Monday, Wednesday, and so on. When I sort this column in ascending sequence, Friday comes before Monday. The same problem happens with month names, which sort as April, August, December, and so on.
- Friday is alphabetically before Monday.
Strategy: Excel has custom lists built in for months and days. To use them, follow these steps:
- Select a cell in your data.
- Select Data, Sort.
- Choose Sort by Day and Sort on Values. In the Order dropdown, choose Custom List.
- Choose Sunday, Monday, Tuesday from the Custom List dialog. Click OK.
Excel will sort the data correctly.
- Weekdays are sorted correctly.