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 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 ...