RE: How do I filter for more than 2 "does contain" criteria

My issue is solved! It was pretty simple:

I have to mark keywords for both: data and search criteria.

Now everything is fine.

Thanks for your support!

Alex

"Alex" wrote:

The data area has a column heading:

data:

D11: Keywords
D12: word1
D13: word2
D14: word3

filter criteria:

D4: Keywords
D5: *word2*

It is not working with word2, *word2* and ="=word2".

I did everything like explained in the excel help, but it is still not
working.

Do you have any additional idea?

Thanks,

Alex

"Ron Coderre" wrote:

Does your list of words in the data area have a column heading?

Example:
D11: Keywords
D12: word1
D13: word2
D14: word3

etc

Criteria range:
D4: Keywords
D5: *word2* (or just word2, if you want an exact match)

"Keywords" over the criteria range tells Advanced Filter to look in the
column with that heading in the data range.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Alex" wrote:

Hi Ron,

thanks a lot for you inputs, but this does not work in my case.

I have a column called keywords.

I added :

D12: word1
D13: word2
D14: word3

The search criteria is the following:

D4: keywords
D5: *word2*

If I start the advanced search as you explained I see only word1. Word2 and
word3 are removed. However only word2 should be visible.

I don't know what is going wrong.

Thanks,

Alex

"Alex" wrote:

I want to filter a table with at least 5 "does contain" criteria.

However this is not possible with the "Auto Filter" and I couldn't figure
out how the "advanced filtering" worked.

Can anybody give me some ideas?

Thanks,

Alex
.

Relevant Pages

  • RE: How do I filter for more than 2 "does contain" criteria
    ... D11: Keywords ... I did everything like explained in the excel help, ... Criteria range: ... "Keywords" over the criteria range tells Advanced Filter to look in the ...
    (microsoft.public.excel.misc)
  • Re: SSH pubkey or password based on user group
    ... >> key while every other user can choose whether they will login using ... AN> than ssh. ... the keywords on the following lines ... available criteria are User, Group, Host, and Address. ...
    (comp.security.ssh)
  • RE: Match Criteria or display All Records
    ... I think they want to do an OR multiple search and it's really causing me ... > and then in the criteria line put Is Null on an or line. ... > To do multiple keywords search is more complicated. ... else display records that match ...
    (microsoft.public.access.queries)
  • RE: Adding keyword to use for a search
    ... I missed the second part of your question - Searching on more than one key ... Then on the next criteria row use -- ... If you want it to contain both of the keywords use -- ... "Anna, Sweden" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Accessing Search Criteria
    ... - access the Search criteria (keywords) in new web part on the same page as the current SearchResults web part ... have that new web part execute as well as the SearchResults web part when 'Search' is clicked ... We'd like to add this new part part so that we can do some specialized, non-portal processing separately from the normal portal search, but have their results displayed concurrently. ...
    (microsoft.public.sharepoint.portalserver)