Filter Criteria

Y

Yaasien

Excel Filter Criteria ="abcd" but result includes "abcdefg" How do I restrict
results (in one cell) to just "abcd"
 
D

Debra Dalgleish

For the criteria, use: ="=abcd"

Excel Filter Criteria ="abcd" but result includes "abcdefg" How do I restrict
results (in one cell) to just "abcd"
Click to expand...
 
Y

Yaasien Parker

Brilliant.
Now if I have this in a macro it will not accept it. The macro reads ...
ActiveCell.FormulaR1C1 = ""=abcd"" and it doesnt want to accept "" times two.
 
D

Debra Dalgleish

Sometimes the macro recorder can help -- if you turn on the macro
recorder while you type ="=abcd" in a cell, you'll see how it's modified
in the code:

ActiveCell.FormulaR1C1 = "=""=abcd"""
 
Top