Advanced Filter not working

B

babypenquin

Excel 2003 has just been installed on my computer and I was trying to use the
advanced filter feature prior to creating a pivot table fromt he filtered
data. The problem is that advanced filter does not seem to be working at
all. The list is not filtered based on the criteria. I have reviewed the
"Filter by using advanced criteria" in help and tried to duplicate the
example, without success. What is wrong??

Type Salesperson Sales
=Davolio



Data
Type Salesperson Sales
Beverages Suyana 5122
Meat Davolio 450
Produce Buchanan 6328
Produce Davolio 6544

Result of running advanced filter
Type Salesperson Sales
Beverages Suyana 5122
Meat Davolio 450
Produce Buchanan 6328
Produce Davolio 6544
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top