Hi Folks,


Need your help in solving this problem using vba

I have a block of data that looks like this in excel

P Q R S T
__________________
a y 0 0 100
a y 0 0 -100
b z 0 98 0
b z 0 96 0
c u -1 0 0
d e 50 0 0
d e -50 0 0

Rows 1 and 2 to be deleted as T1 and T2 match (ignoring the - sign.)
Rows 3 and 4 stay in the sheet as S3 and S4 are unequal
Row 5 stays as it is the only row with no duplicated row
Rows 7 and 8 to be deleted as R7 and R8 match.

Can you folks help me in this regard?