Chapter 49. 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 2013 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 can I clear filters from a column ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

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