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