Thread: [Solved] Pivot table v Advance filtering v Macro v VLookup
View Single Post
 
Old 04-15-2016, 11:24 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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).
Attached Files
File Type: xlsx AdvFilter.xlsx (70.8 KB, 13 views)
Last edited by xor; 04-15-2016 at 05:08 PM.
Reply With Quote