Chapter 14. Sorting Data
In this chapter
Introducing the New Sort Dialog 288
Sorting data is one of the key capabilities of a spreadsheet program such as Excel. With a click of the mouse, you can rearrange data so that it is presented in an alphabetical sequence or in a sequence with the largest numbers at the top or bottom of a list of data.
One of the considerations when sorting is what happens when there are ties in the column upon which the sort is based. If you have a database of product sales and sort the data by the product field, it is likely you will have many rows with identical products. In that case, you can specify a secondary sort criteria. You might want to ...
Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
