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

For the criteria, use: ="=abcd"


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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

"Debra Dalgleish" wrote:

For the criteria, use: ="=abcd"


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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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"""


Yaasien Parker wrote:
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.

"Debra Dalgleish" wrote:


For the criteria, use: ="=abcd"


Yaasien wrote:

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html