O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

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

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

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