Identifying Certain Values in Columns Excel

[Conell8383]

I hope someone can help. I have an excel sheet with over 65,000 rows. I have attached a picture of what I am trying to achieve
The problem I am facing is that i have a worksheet with 65,000 rows, and I have payments and reimbursements withing these rows. In the below screen shot you can see that customer Adsay Fahrettin, customer id 17706421 was paid 800 euro Column J cell J2 and that payment was made on 11/16/2015 Column N Cell N2.
Then customer Adsay Fahrettin, customer id 17706421 has the 800 taken back from him Column J cell J3 and that transaction happened on 1/4/2016 Column N Cell N3.

There are 100's more of these transactions in the worksheet how can is there a way to identify?
Any help would be greatly appreciated

 

[Conell8383]

Hi

 

[bhos123]

is it still pending? Thought the last code worked. Can you tell me what's happening with the last code. I tested with my file. it's worked fine.

 

[Conell8383]

The Excel sheet is huge over 280,000 lines its just hanging for ages it is stuck processing.

 

[bhos123]

can you try with a copy of say 1000 or 10000 rows and see how much time it is taking.