I love advanced filters, but this week they caused me some serious grief.
Advanced filters in Excel are quick and powerful, and I use lots of them. They’re a great way to pull a list of unique items from a table, or send specific data from one sheet to another.
People sometimes have trouble with an advanced [...]