Hello Everyone!
Is there a way to deal with blank cells in a criteria range when using the Advanced Filter?
In the illustration below, Column A:C is the 'List Range', Column E will contain data for the 'Criteria Range' and column G1:I1 is the 'Copy To' destination.
When using the Advanced filter and selecting E1:E3 with no blanks, I get the desired results in the Copy To destination.
However, if the criteria range is extended down selecting E1:E5 (to include 'Team 5') if the range contains a blank, the filter returns all of the data in the list range vs. Team 1, 2, & 5.
Thanks in advance for your feedback.
<tbody>
</tbody>
Is there a way to deal with blank cells in a criteria range when using the Advanced Filter?
In the illustration below, Column A:C is the 'List Range', Column E will contain data for the 'Criteria Range' and column G1:I1 is the 'Copy To' destination.
When using the Advanced filter and selecting E1:E3 with no blanks, I get the desired results in the Copy To destination.
However, if the criteria range is extended down selecting E1:E5 (to include 'Team 5') if the range contains a blank, the filter returns all of the data in the list range vs. Team 1, 2, & 5.
Thanks in advance for your feedback.
A | B | C | D | E | F | G | H | I | |
1 | Team | Score | Date | Team | Team | Score | Date | ||
2 | Team 1 | 60 | 12/1/17 | Team 1 | |||||
3 | Team 2 | 50 | 12/1/17 | Team 2 | |||||
4 | Team 3 | 80 | 12/1/17 | ||||||
5 | Team 4 | 70 | 12/1/17 | Team 5 | |||||
6 | Team 5 | 90 | 12/1/17 | ||||||
7 | Team 1 | 40 | 12/2/17 | ||||||
8 | Team 2 | 60 | 12/2/17 | ||||||
9 | Team 3 | 50 | 12/2/17 | ||||||
10 | Team 4 | 20 | 12/2/17 | ||||||
11 | Team 5 | 80 | 12/2/17 |
<tbody>
</tbody>