Joanne has attended:
Excel Intermediate course
Sorting
Sequence of sorting with more than 3 criteria...
RE: Sorting
Hello Joanne
Thank you for your question and welcome to the forum.
OK, so here's what you need to do. Say you are sorting by 4 columns:
1. First, select a cell in the database.
2. Go to Data-Sort.
3. In the first Sort by box, select the column that you wish to sort by last (after all the others). Click OK.
4. Go to Data-Sort again.
5. In the Sort by and Then by boxes, select the other three columns you want to sort by, starting with the most important first. Click OK.
I hope this helps.
Kind regards
Amanda