Filter Data by Checkbox Selections: Single Column + Multiple Columns (Google Sheets)

Question

I am trying to figure out how to allow folks to filter a data set by clicking on checkboxes of their choice. Here is a sample spreadsheet to will better help explain my objectives. I have two separate tabs: one to filter using only one column of checkboxes, and another that looks to filter data using multiple columns of checkboxes.

Thank you very much in advance!

Answer 1

You may try:

=filter(A5:B,xmatch(year(A5:A),filter(E5:E,D5:D)),xmatch(B5:B,filter(H5:H,G5:G)))