Advanced Filtering top values
 

Basicly what I need to be able to do is to advance filter a list by
the top 25 values in column E. I have a crietra that consist of
filter by year, product and value . Year and Product are easy it is
trying to get the list to filter by the top 25 values that is hard.
What formula do I put in the critera cell that will allow me to filter
the entire list based on the top values

Advanced Filtering top values
 

Excel 2007 Advanced Filter
Macro, with top 10 filter.
Alternate solution: PivotTable:
No code, no formulas needed.
http://c0718892.cdn.cloudfiles.racks.../04_16_10.xlsm