I am working on a huge data file. There are many rows & columns. I want to delete those rows which has same name and also same positive & negative value and are of same week.

For example

Suresh, +40, 07 JAn(weekend)
Suresh, -40, 07 Jan(weekend)
Suresh, +30, 14 Jan
Suresh, -30, 21 Jan
Suresh, 15, 21 Jan

In above example, I expect it to be like -

Suresh, +30, 14 jan
Suresh, -30, 21 Jan
Suresh, 15, 21 jan

and rest to be deleted automatically.

Suresh, +30, 14 jan & Suresh, -30, 21 Jan should not get delete as they are of different week.

Please guys, help me out!!