O'Reilly logo

Microsoft® Excel® 2010: 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 46. Filtering Data and Removing Duplicates

Questions answered in this chapter:

Joolas is a small company that manufactures makeup. Its managers track each sales transaction in a Microsoft Excel 2010 worksheet. Sometimes they want to extract, or “filter out,” a subset of their sales data. For example, they might want to identify sales transactions that answer the following questions:

  • How can I identify all transactions in which Jen sold lipstick in the East region?

  • How can I identify all transactions in which Cici or Colleen sold lipstick or mascara in the East or South region?

  • How can I copy all transactions in which Cici or Colleen sold lipstick or mascara in the East or South region to a different worksheet?

  • How do I clear filters from a ...

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