Delete row if some columns equal others

How should I make a code that deletes rows if:
Some value in column B has its symmetric in column B as well AND Column E coincides for both. If TRUE, I want to delete the row with the positive value.

Hope someone can give me a help!

Thanks in advance

I did something like the following but I don't know how to make it ANY row instead of +1 neither how to make it delete the positive B column value row.

Please Login or Register  to view this content.

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)



Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.