Chapter 40. Filtering Data and Removing Duplicates

Joolas is a small company that manufactures makeup. They track each sales transaction in a Microsoft Office Excel spreadsheet. There are times when 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 column or database?

  • How can I ...

Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.