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

 

[bhos123]

suppose we have 100 different transactions for the ID - 17706421, what do you want to it with then?

 

[Conell8383]

Hi thank you for taking the time to respond.
I don't want to do anything with the other transactions. I only need to identify a positive transaction made in 2015 and then the corresponding negative transaction made in 2016. If both the positive transaction and the corresponding negative happen in the same year. This is not an issue. I only need to identify where the year over laps for the negative in 2016.

 

[Sektor]

You could use Autofilter or Advanced Filter.

 

[bhos123]

=AND(j2>0,year(N2)=2015)

 

[Conell8383]

Hi Bhos123 thank you for the suggestion I typed =AND(j2>0,year(N2)=2015) into cell K2 and i got the below error #VALUE! Have i done something wrong?

 

[bhos123]

As you have added a column it should be O2: =AND(j2>0,year(O2)=2015)

 

[Conell8383]

@bhos123: =AND(j2>0,year(N2)=2015) worked once I figured it out Thank you. now i can identify the positives in 2015. The last piece of the puzzle is how to identify the corresponding negative? Any help would be greatly appreciated

 

[bhos123]

are the negetive payments are of same amount values?

 

[Conell8383]

They are identical they just have a negative see below