Filter Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel Filter Criteria ="abcd" but result includes "abcdefg" How do I restrict
results (in one cell) to just "abcd"
 
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...
 
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.
 
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"""
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter not pulling exact matches 1
Restricting more than x number of characters in a cell.... 1
Mid/Len functions 7
advance filter 6
?? advance filter out certain field 1
extracting substring 3
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
How to separate user name and domain name in email id? 2

Back
Top