Microsoft Office Tutorials and References
In Depth Information
Working with the Sort Command
Reordering and Adjusting
Your Sort
What are those triangles and the Options
button about? Click the triangles to reorder
your sort levels—using the up-pointing
triangle to move a selected level up in the
sort, and the down-pointing arrow to move
a selected level down in the sort. This can be
handy if you re-think the order of your sort
levels and don’t want to have to delete one
or more of them and start over. The Options
button allows you to fine-tune your sort
even further, turning on Case sensitivity
and changing the orientation of your sort—
converting from a top-to-bottom sort to a
left-to-right sort. The default, of course, is
top-to-bottom.
Figure 7-10
The list of cities, sorted by their healthcare rating,
within each state. The cities are alphabetized.
Tip
If you need to look at a list from more
than one perspective—using fields which
might not have a lot of duplicate entries by
which to create sorted groups—consider
creating a PivotTable report (check out
Chapter 15, “Using PivotTables”) to create
a more flexible, powerful report than a
simple sort can give you.
As you can see in Figure 7-10, the resulting sorted
list makes it easy to see which cities in which
states have the best healthcare rating. The groups
created by sorting on fields with duplicate
records—State and Healthcare—make it easy to
interpret the data. Instead of Healthcare, the
Economy or Education fields could have been
used (one or the other), depending on what’s of
interest to you or those who’ll be viewing the
list. Sorting by two of the ratings would make it
harder to use the list in an “at a glance” way,
however, as it would break up the groups created
by duplicate entries in just one of the rating
fields.
 
Search JabSto ::




Custom Search