I have a spreadsheet with multiple columns. I want to be able to filter by any or all selected criteria from a set of drop down lists.

The filter I currently have at A25 is an all or nothing. If all drop downs aren't matched (including blanks) it returns nothing.

I want to be able to select as few or as many of the drop downs as I desire and have the filter only apply to the drop downs I've selected.

If a drop down is left blank, that would be ignored from the filter allowing any data in that column through if the other selected criteria matches.