Filter By Any Or All Criteria

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.

Tried uploading a sample spreadsheet. Doesn't look like it's working.

I can see the file in 'Manage Attachments' but can't seem to get it attached to the post. When I click the attachment drop down, it is blank.

That time it worked.

I mean the upload worked. I'm still lost on the initial question.

Originally Posted by rorya

The headers in your criteria range and output range need to match the headers of your data range.

Not sure I understand.

I'm referencing selected ranges.

So in the example sheet, if I select E as the company in A22 and leave the other 3 drop downs blank. It is not going to return me any results because there are no entries in the raw data above where that is the case.

That is where my hang up is. I want to select as many or as few criteria as needed and return results only based on selected criteria.

So let's say I want to see all the jobs Bob did. I should be able to leave the drop downs for Company, Location and Job Number blank. Just select Bob in the Tech drop down and see all the jobs Bob did.

Thanks for the replies.

Okay. I see what you did, but that seems to be a one and done proposition. After the advanced filter is executed, it does not stay active. So in order to change the filtered results, I have to select my drop downs and then rerun the advanced filter. That is too complicated for the people who are going to use this. I need this to be an active filter. Each time a drop down is changed, the filter automatically updates as they are going.

I suppose I could run a macro on a push button that would execute the advanced filter.

That's it! Outstanding. So the plus generally acts as an "or" between the criteria or blank just as the * acts as "and" between the statements? Is that right?

I appreciate the help. I have been racking my brain on this for 3 days. Thanks a million!