Advanced Filter to return Rows w/blank column

I have a worksheet which shows multiple tests and whether they are completed or not[code]Test 1 Person1 Test 2 Person2 Test 3...Person12
I want to search for a specific test, e.g. pH which could be in any of the "Test" columns but only return it if it is not completed. The "Person" columns will be blank if no one completed the test.

I set up the Advanced Filter criteria with all the appropriately labeled columns and for the Person columns, I put ="" but it is returning all rows which have pH in them whether they are completed or not. What should I be putting in the Person columns of the criteria to only return those rows which have the pH test but it is not completed.

I attached an example of the criteria range and the filter window to help clarify (the full spreadsheet is huge)

I already have too many columns. I think what I will do is set all the "empty cells" to hold " " and that I can do an advanced Filter on. I'm just surprised that there is no direct way to do an advanced filter with one of the criteria being that one cell is blank.

After some research and trial and error, I solved the problem as so. I placed the appropriate test name in B2 (data validation dropdown) and for my advanced filter criteria, I removed the headers and used formulas like so

Please Login or Register  to view this content.

where the first colum references are test names and the second column will be blank if the test has not been completed. Solved!