Formulas and Functions with Microsoft® Excel 2003

13. Analyzing Data with Lists

IN THIS CHAPTER

Converting a Range to a List

Basic List Operations

Sorting a List

Filtering List Data

Summarizing List Data

Creating Automatic Subtotals

Excel’s List Functions

Case Study

Excel’s forte is spreadsheet work, of course, but its row-and-column layout also makes it a natural flat-file database manager. In Excel, a list is a collection of related information with an organizational structure that makes it easy to find or extract data from its contents. Specifically, a list is a worksheet range that has the following properties:

• Field—A single type of information, such as a name, an address, or a phone number. In Excel lists, each column is a field.
• Field value—A single item in a field. In an Excel list, ...