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

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