I know this is an old post, but someone may be able to use this bit of code.
(Uses VBA)
Range("A3:H3").Select
Selection.AutoFilter
Selection.AutoFilter Field:=4, VisibleDropDown:=False
Selection.AutoFilter Field:=7, VisibleDropDown:=False
This will put filter dropdown arrows from "A3:H3" for those people who have multiple header rows.
It will then remove the dropdown arrow from the 4th & 7th columns (D & G) so that the only columns that are filtered are A-C and E-F and H.
Hope this clears up some questions about unique filters.
Bookmarks