|
|
#2
04-15-2016, 11:24 AM
|
|||
|
|||
I would prefer Advanced Filter and have tried to do just that in the attached in sheet RESULT cell U9:AL100 with Criteria range in U1:W5.
It seems to work reasonably well but there are some problems that I can't explain. As you can see I try to compare your results in A9:R101 with those generated by Advanced Filter in U9:AL100 in AN9:BE100. Please note that these formulas return 7 FALSE's in row 18 and row 92. Edit I now realize that the above problem is due to the fact that there are duplicates of the headings in row 8 in sheet RAW DATA (two instances of FY12, FY13 etc. I tried to change L8 to FY12_2, M8 to FY13_2 etc. and it worked fine). Last edited by xor; 04-15-2016 at 05:08 PM. 
|
| Tags |
| advance filtering, macro, pivot table |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
|
Filtering (advanced?) in Pivot Table
|
canajun | Excel | 6 | 01-17-2015 05:01 AM |
| Excel Macro to "Select All" in Pivot Table Field | galkej | Excel | 0 | 02-03-2014 11:59 AM |
| Help with pivot table macro | ejima | Excel Programming | 2 | 02-16-2012 03:45 PM |
| VBA: Recording a macro to insert a PIVOT table | e093223 | Excel Programming | 0 | 10-09-2011 01:55 AM |
Windows 10 
Office 2016
Threaded Mode