I have a set of data that I want to filter by both the rows and columns.
I want to create a function like
FILTER(B4:L8, (B2:L2 = "Email")+(B2:L2 = "All"), A4:A8 = "Email") to filter the data in the image below. However this does not work, how would I go about this?
Example Google Doc: https://docs.google.com/spreadsheets/d/1JIGXmOKkb_llfnrfJmdbiwFG97tiL3E3PnDuhy3r9x8/edit?usp=sharing