CODEWITHSUNDEEP
google-sheetsfilterfilteringspreadsheetcheckboxlist
user19438699
user19438699

Reputation:

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

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!

Upvotes: 0

Views: 58

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 29982

You may try:

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

enter image description here

Upvotes: 0

Related Questions