Remove rows base on conditions

[Anonymous]

HI, how to I remove rows base on conditions?

Group,name

A, Peter

A,Tan

A, Allen

B,Jacky

B,Tracy

B,Tom

I want to remove Group A because one of the name is Peter.

When I use    if(name <> Peter,1,0)  // I hides the 0's  , the other name in group A still shows. How do I remove them as well?

[Anonymous]

Alright! I understand. thks!