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 ...
Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
