O'Reilly logo

Formulas and Functions with Microsoft® Excel 2003 by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required