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
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) | Volume | Yes/No |
South | 10 | Yes |
West | 15 | No |
North | 10 | No |
South | 5 | No |
South | 20 | Yes |
West | 5 | Yes |
Region (filter) | Rate | Colour |
West | 5 | Red |
South | 1 | Blue |
North | 2 | Blue |
West | 5 | Red |
North | 1 | Yellow |