Adding additional criteria points

**dwhite30518** · 08-26-2015, 03:27 PM

Hello fellow forum users!!!

I have the following code that works great but it only works with one criteria point and I have 2 criteria points that I want to use...

Please Login or Register  to view this content.

So what is the best way to modify this code to include multiple criteria points?

**Kaper** · 08-27-2015, 08:53 AM

The code can remain unchanged. Just change (Ctrl+F3) definition of "Criteria" range, to include more criteria. And of course write your additional criteria there. See how to formulate criteria here https://support.office.com/en-ie/art...8-3f16abdff32b or may be easier to read for instance here: https://blog.udemy.com/excel-advanced-filter/