Chapter 49. Filtering data and removing duplicates

Questions answered in this chapter:

Image Joolas is a small company that manufactures makeup. Its managers track each sales transaction in a Microsoft Excel 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 the transactions in which Jen sold lipstick in the East region?

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

• How can I copy all the transactions in which Cici or ...

Get Microsoft Excel 2016 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.