Re: Search for multiple strings in a list (w/in 1 cell) w/ Advance

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I think what Jim gave you works OK for me. Here's a sample if the email
doesn't change everything:

Secondary Languages Secondary Languages Secondary Languages Lang.
*german *Japanese *arabic
*arabic

*english

*french

*german

*italian

*Japanese
Users Name Secondary Languages
Joe french, german, italian
Fred Japanese, french, arabic, german
Ben Japanese, french, arabic,italian
Tom german, french, arabic, Japanese
Bill english, german, french


This shows three Criteria blocks and the entry order of the languages
doesn't matter. I would suggest you list all your languages in a column to
the right so you can select what you need and paste it in. If one or two of
your entry blocks is blank it won't matter.

CHORDially,
Art Farrell







"Maher" <Maher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:57C9C366-F147-48BE-AB1C-BB99B5A439F0@xxxxxxxxxxxxxxxx
Thanks for the reply Jim,
Currently, I can search in 2 ways ,
I search for *german *french OR *french *german (2 rows of criteria)
or I search for french first and filter the results for german.
(By the way *german* *french* work exactly the same)

But what I wanted to do is to just search for (german, french), regardless
of the order, in one step. Especially if I search for more than 2
languages
and it will take more lines of criteria or more successive filtering. Just
imagine, for 3 strings I need 6 combination, i.e. 6 rows of criteria, or
three successive filtering. This can be annoying for regular users.

Also the problem, in first place, is that I don't know what languages the
users will input, so really I can't have separate column for each
language.
And also, I have the same problem in different fields, not just the
language.
Thanks

"Jim Rech" wrote:

I don't know how it will work in practice but you might trying doing
something with two (or more) criteria cells. Like this for French and
German:

Lang Lang
*french* *german*


Yes, you can have field names more than once in your Criteria range.

--
Jim
"Maher" <Maher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E5B18938-7B84-415D-9C09-DB3AEFEE7C52@xxxxxxxxxxxxxxxx
| Hi,
| I'm using Advanced filter, to search for a different criteria and now
I'm
| stuck with this problem. One of my columns contains a list os
secondary
| languages:
|
| Users Name Secondary Languages
| Joe french, german, italian
| Fred Japanese, french, arabic
|
| Using advanced filter, if my criterion is *french*german , it yields
Joe,
| which is great, but if my criterion is *german*french it yields
nothing.
| Is there anything in excel like `*{german, french}` where it can find
the
| two strings regardless of their order?





.

Relevant Pages

  • Re: No call for Ada (was Re: Announcing new scripting/prototyping language)
    ... Programming languages are also tools for thinking. ... > people of Quebec unless you can think in French. ... that viewpoint is viable and somehow appropriate for its native environment ... "I am a German, flying a German airplane, in Germany. ...
    (comp.lang.ada)
  • Re: Portable CP/M
    ... German languages: Angle, Saxon, and Frank. ... Nobility: that is to say: French Nobles who were given lands following ... This fact can be seen if you study the English language. ...
    (comp.os.cpm)
  • Re: Design Questions about static factory classes
    ... French-language JVM, read the Java API in French, and write my system ... languages of the system and of its developers. ... supporting english, french, and german as languages. ... I think the JVM default locale is ...
    (comp.lang.java.programmer)
  • Re: Bernsteins Debussy - Whats not to like?
    ... the nit-picker, being in two different languages, most people would ... "get" the joke that the article used was German, and not French. ... Certainly the joke has more to do with the "harshness" of one language ...
    (rec.music.classical.recordings)
  • Re: Search for multiple strings in a list (w/in 1 cell) w/ Advance
    ... The multiple criteria columns worked for me. ... Users Name Secondary Languages ... or I search for french first and filter the results for german. ... | I'm using Advanced filter, to search for a different criteria and now ...
    (microsoft.public.excel.misc)