Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Delimiter Advanced Filter

  Asked By: Kuhaylah    Date: Mar 26    Category: MS Office    Views: 865
  

Follow the case:

I´ve the criteria that I used in my advanced filter (in the yellow box), in this
case, the filter considering only the letter "S".


But when I applyed the advanced filter (screen shot below), Excel grouping all
the cells that contains "S".


How I delimite the advanced filter that grouping only the cells that contains
one "S" ?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Michele Grant     Answered On: Mar 26

Sorry... Are you using "Advanced Filter" or "custom filter"?
If you're using "custom filter",
I did one where I said "Contains": "S"
and "does not contain", "S*S"
and it worked to exclude those with more than one "S"...

 
Didn't find what you were looking for? Find more on Delimiter Advanced Filter Or get search suggestion and latest updates.




Tagged: