Multiple Filters

mason001

New Member
Joined
Dec 6, 2017
Messages
9
Hi everyone, I've tried searching and googling but what i'm asking isn't giving me the answers relevant to what i'm after.

Basically, I've got two tables on one sheet - is it possible to have filters at the top of each table within the same sheet and column? (as below example). As I can only seem to apply one filter for either the top or the bottom table - say for example someone from the West wanted to see only their data for both tables, i'd want them to be able to click the drop down filter and select West so it only displays their stuff.

TIA

Region (filter)VolumeYes/No
South10Yes
West15No
North10No
South5No
South20Yes
West5Yes

Region (filter)RateColour
West5Red
South1Blue
North2Blue
West5Red
North1Yellow
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
You will need to convert the data into structured tables.
 
Upvote 0
You will need to convert the data into structured tables.

Nice one, thank you very much, that's worked perfectly
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top