Microsoft® Excel Data Analysis and Business Modeling

Chapter 38. Filtering Data

Joolas is a small makeup company. In an Excel spreadsheet, they track each sales transaction. They often want to extract, or "filter out," a subset of their sales data. For example, they often want to identify sales transactions that satisfy the following conditions:

• All transactions in which Jen sold lip gloss.

• The ten largest transactions (by revenue).

• The bottom 5 percent of transactions (by revenue) in which Colleen was the salesperson.

• All 2005 lipstick transactions in which Ashley was the salesperson.

• All foundation transactions in the first six months of 2005 in which Emilee or Jen was the salesperson and the average per unit price was more than $3.20.

Excel’s filtering capabilities make identifying the subset of ...