Hi guys
I'm having a lot of difficulty trying to figure out if/how I can make this work. Bear with me while I explain what I'm trying to achieve:
You know when you filter data and in the column heading, it has the drop-down arrow with the checkboxes that allow you to filter based on the contents? Like, say you have 'Brands of Car' as your heading and under that you have Mitsubishi, Toyota etc., and you can tick whether or not to display records that contain that model?
I'm trying to get these checkboxes to appear ABOVE the table, because I know for sure my co-workers aren't even going to attempt to use this document if they have to to use filters by going into the heading.
For example, above the table with the data I'm looking to have something like...
I would post the spreadsheet but the data is kind of sensitive.Show all results: []
Show results for: [] Mitsubishi [] Hyundai | [] 4 cylinder [] 6 cylinder | [] Two-door [] Four-door
Brands of Car | Cylinders | Doors
Does that make sense? Is this possible? The 'Show all results' checkbox is totally optional but would be a big bonus - really just looking for a way to display the individual checkboxes.
Thanks for your help :D
Bookmarks