Filtering list basis one criteria

[sguna1982]

Dear Team,

I am looking for formula for based on the one criteria like search "ABC", if the text in available in the selected cell, i want to copy the required range in another range.

Please help.

Thanks

 

[Hui]

Sguna

I'm confused as 3 of your expected result rows don't include ABC?
1-Aug-14 REJECT:237007RESENT IN PROPER ZONE 1,262,853.00
4-Aug-14 REJECT:61351:FUNDS INSUFFICIENT 688,337.00
5-Aug-14 RTN CHG-61351/FUNDS INSUFFICIENT/01.08.14 112.36


Have you had a look at: http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[sguna1982]

Dear Hui,

Thanks for your quick reply,

If B3:B11 column contains "ABC" , i want the entire range should be copied some other filed, if not it should be exclude. B4:B6 is not contains of the particular text that's what i removed .

Thanks

 

[Hui]

That doesn't make sense as your expected results include and exclude ABC


Can you please specify what rules you require to include / exclude a record from the source to the expected results?