I'm able to use advanced filter with wildcards that are values only.
How do you use wildcard advanced filter using a formula.
Sheet3
<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 87px"> <col style="WIDTH: 64px"></colgroup> <tbody>
</tbody>
<tbody>
</tbody>
This formula does not work for looking up values using wildcards.
What's wrong with the formula?
How do you use wildcard advanced filter using a formula.
Sheet3
A | B | |
1 | Column A | |
2 | adfd dog g | |
3 | dfdf green gfdf | |
4 | sghwfh cat fdfd | |
5 | fafad mouse fdfd | |
6 | ||
7 | ||
8 | Criteria | |
9 | Green | FALSE |
10 | Mouse |
<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 87px"> <col style="WIDTH: 64px"></colgroup> <tbody>
</tbody>
Spreadsheet Formulas | ||||
<tbody> </tbody> |
<tbody>
</tbody>
This formula does not work for looking up values using wildcards.
What's wrong with the formula?