Hi
If anyone can help me with the following problem I would be very greatfull, I am an accountant and I need to match columns with duplicate values and delete both rows so that the only values that are left are the ones that could not be matched for example Cell A1 has a value of 500 and Cell B3 has a value of 500 and Cell A2 has a value 200, So I need to delete A1 and B3
Please see the attached document, to try and explain to me what I need to do, if you can give me a Macro (please explain in detail how to wright a macro, my programming is amateur at best) or another solution I would appreciate it. This example is small, I have to deal with excel sheets that have about 5000 to 16000 lines, I don't have the time to sort the columns and delete all the duplicates manually.
Bookmarks