Hi all, I have data in sheet (see below)

ROW A E F-----col
1 3080 G16 11
2 500 G16 12
3 -3080 G16 11
4 3080 G16 11
5 -3080 G16 11
6 -3080 G16 12
7 5040 G34 11
8 52590 G34 12
9 -5040 G34 11
10 5040 G34 11
11 -5040 G34 11
12 -5040 G34 12

I want macro which should check values in column E and F in row by row
like E1 & F1 and if E1 & F1 value match in any other row of column E
and F like in above table I have G16 and 11 in cell E1 & F1 and excect
value in cell E3 & F3 and so on. So when same row value in column E
and F match and in the same row of where those value matching if they
have debit and criedit amount in column A then both debit and credit
figures rows should be deleted. i hope that i have explained what i
am trying to say. Please if any friend can help.

Macro should bring result like this (see below)

ROW A E F-----col
1 500 G16 12
2 -3080 G16 12
3 52590 G34 12
4 -5040 G34 12