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