Filter based on multiple or condition

Hi Everyone,
Is there a way to filter data based on multiple OR condition with a like parameter.
I have data which has near about 50000 rows and now i would like to filter on a header called "Activity Type" and would like to fetch result for a text which resembles "from ABC group" or "From PQR group" or "From XYZ group".

hi mangesh. assuming data in A1:D10, you can do a formula in G2:
=OR($A2={"from ABC group","From PQR group","From XYZ group"})

then go to Data tab -> Advanced.
List Range:
Sheet1!$A$1:$D$10
Criteria Range:
Sheet1!$G$1:$G$2

then press OK. another way is to list all the conditions you want in G1:G3:
Activity Type
from ABC group
From PQR group
From XYZ group

then criteria range is now:
Sheet1!$G$1:$G$3

if it doesn't work, I suggest you upload an Excel file in the thread. To do that, Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
and to illustrate your example better, click on How To Get Quick & Good Answers

Hi Benishiryo,
Appreciating your help. However in "Activity Type" i have the word from ABC group, from PQR group along with other text.
For example "reassigned from ABC group to STW group". Here the challenge is to read "from ABC group" from entire text and then apply the formula.

Try like this...

=IF(SUM(COUNTIF(A2,{"*from ABC group*","*From PQR group*","*From XYZ group*"})),"Found","Not Found")

put in this formula in G2:
=OR(ISNUMBER(SEARCH({"from ABC group","From PQR group","From XYZ group"},$A2)))
or:
=SUM(COUNTIF($A2,{"*from ABC group*","*From PQR group*","*From XYZ group*"}))>0

or use asterisk for this list in G1:G4:
Activity Type
*from ABC group*
*From PQR group*
*From XYZ group*

Hi Sixthsense,
Thank you very much, its working.
I also appreciate help provided by Benishiryo.