How to delete a filtered set of rows through macro

How can we delete the rows which has "male" in this table?

name	gender
aaa	male
bbb	female
ccc	female
ddd	male

the output should be,

name	gender
bbb	female
ccc	female

Thanks in advance

Hi

Here is one way, not filtering though.

Please Login or Register  to view this content.