How to filter XML file with multiple criteria

I am a complete newbie to coding and I'm having a problem with a task that I have where I have to filter multiple XML files based on certain criteria:

Filter sheet based on a certain value for Column D -> Filter sheet based on a certain value for Column B -> Find the value in Column C in the same row as the certain value for Column B -> Delete all rows with the value in Column C.

I can do the first three steps fairly fast but the problem is with deleting all the rows with the value in Column C. I can only efficiently delete the row with the value of Column B and C.

This is what I want to happen:

| Column A | Column B | Column C | Column D |
|    1     |     A    |     1    |    B     | 
|    2     |     B    |     1    |    A     |
|    3     |     C    |     2    |    B     |
|    4     |     D    |     2    |    B     |
|    5     |     A    |     3    |    B     |
|    6     |     E    |     3    |    A     |

First, is to find all rows with a certain value "B" in Column D:

| Column A | Column B | Column C | Column D |
|    1     |     A    |     1    |    B     | 
|    3     |     C    |     2    |    B     |
|    4     |     D    |     2    |    B     |
|    5     |     A    |     3    |    B     |

Second, is to find rows with a certain value "A" in Column B:

| Column A | Column B | Column C | Column D |
|    1     |     A    |     1    |    B     | 
|    5     |     A    |     3    |    B     |

Third, is to find the value of the rows in Column C then delete all rows in the whole XML file with the values in Column 开发者_如何学编程C as "1" and "3":

|    3     |     C    |     2    |    B     |
|    4     |     D    |     2    |    B     |

It takes me 2 hours to get through one XML file and I have 25 total files to go through so I really need your help.