Deleting Rows with coinciding positive and negative values

Hello, new here and I apologize if I don't follow the correct etiquette, nonetheless, I wanted to know if there is a way to write a formula which can delete rows if it meets certain criteria and it has corresponding positive and negative values, for example, say we have the following three values columns


2856467 99745 1
2856467 99745 -1
4556434 87452 2
1856434 78549 7

The formula I thought would be, =IF(A1=A2,IF(B1=B2,C1+C2,""),""), which I know is incorrect, but it was my first attempt. Essentially, what would make this better would be to have it check al four entries on column A, and then once it finds a match have it check all four entries in B, and once again when it finds a match then if the values in C coincide but are inverses of each other, i.e. one positive-one negative then these two would be deleted. If these conditions were not met we would leave them alone. Would this be something that would be possible to do? Thank you all help is greatly appreciated, as I am still a beginner in Excel.
_____________________________________________________________________________________
I have added a sample excel worksheet for the sample data. The concept remains the same, I would like to check column A, column B and then delete the positive and negative values in column D with their respective rows, if the criteria is met, as described above (this corresponding to the sample worksheet provided). Would this be possible using formulas and functions, if not delete perhaps identify. Or if I would have to use VBA, how and where could I get started as I have no experience with this aspect of Excel. Thank you.



_______________________________________________________________________________________
I have updated the sample excel workbook, so that it is more concise and in-line with my target question. Thank you

I have also, asked this question in Mr.Excel, but it won't allow me to post the link

https://www.mrexcel.com/board/thread...alues.1150355/ link added by Moderator

if you are saying that if you have duplicates in columns A, B, C and D and you want those removed you can highlight the area and go to the Data tab then open Remove Duplicates then it will open a window with columns A, B, C and D checked and you just hit ok and all the duplicates that occur in all four columns will be removed leaving only the ones that are not duplicated in all four columns.
if that isn't what you want perhaps indicate in your workbook which ones you would want removed, then maybe a formula could be written that would show which - using a helper column. Otherwise, the VBA option is another area of this forum and you should message a moderator to have this post moved so someone could write the code for you.