Prev: Copy and Paste using VBA.
Next: Array Issues… Please help me….
From: Thomp on 15 Apr 2010 16:52
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
From: Herbert Seidenberg on 17 Apr 2010 01:01
Excel 2007 Advanced Filter
Macro, with top 10 filter.
Alternate solution: PivotTable:
No code, no formulas needed.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_16_10.xlsm
 | 
Pages: 1
Prev: Copy and Paste using VBA.
Next: Array Issues… Please help me….