Filter with blank cells

[srizki]

Hi all,
I have a spreadsheet containing test cases, where each test consists of multiple steps. The spreadsheet has a column (Column S) that contains the names of individuals assigned to each test. I want to filter the spreadsheet so that only my name and my assigned test steps are visible. When i attempt to filter the spreadsheet by my name and blank cells, the filter function displays my name along with blank cells for everyone else, rather than only my assigned test steps.
How do I solve this? Please advise.

 

[srizki]

The issue is that I believe that the Filters only consider the criteria for the particular rows being evaluated, and don't really take into effect where they reside and the criteria of rows around them.
The only way I can think of to do what you want without updating the values in the column would be to use VBA.

Thank you, Joe. I used the helping column to fill in the blank and filter from that column; that worked.

 

[Joe4]

You are welcome.
Glad that was able to work for you.