how do I delete data if specific requirements met.

[ghrek]

Hi

I have a workbook that has data in columns A-G .

What im trying to do is where the data in columns B & D are an exact match in a row I need it to be checked against the values in column G to see if there is a positive and negative figure the same in the row.

Lets say Lines 24 & 25 have matching data in columns B & D and then I column G there is a negative and positive value exactly the same I then need the 2 rows deleted.

Any Ideas?

 

[Marc L]

Hi,​

​

differents ways so difficult without any attachment enough explicit …​

 

[ghrek]

I cant put a workbook on but to make it easier lets say look in Column G for a matching positive / negative figure.

If Column G has a positive and a negative figure for the same amount then I need to check against column D in the same rows to see if the dates are the same. If they are I then need the rows deleted that have the matching positive and negative figure.

Does that help?