This may sound terribly elementary, but I am unable to sort by two different columns. I want to sort by one, then sort by another. Should be basic, right? It is only sorting by the first criteria. Any ideas?
This may sound terribly elementary, but I am unable to sort by two different columns. I want to sort by one, then sort by another. Should be basic, right? It is only sorting by the first criteria. Any ideas?
"(Menu) Data: Sort" pops up a form for entering columns to sort on.
The first field gives the primary column. The rows will sort into order according to the primary.
The second field gives the secondary column. This is used to sort rows for same-values in the primary column, to break ties.
There is a third field that can be used to break ties for same-values in the first two columns specified.
FrankBoston is the pen name for Andrew Garland, Lexington MA
That is correct. I have already done so using the primary and secondary sorts. The problem is, it is not sorting by the secondary at all.
Now it is time to upload an example, a zipped .XLS.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks