Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Alright! I understand. thks!