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