View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maher Maher is offline
external usenet poster
 
Posts: 3
Default Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi

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?