Hello,

I am trying to see if there is a way (I'm doubting whether this is even possible anymore) to highlight or mark items that can offset each other exactly given certain criteria (for this purpose Project and Fund Column B and C). For example: There could be 250, 250, 500 that would 0 out with a -1000 of the same project code however there may be another -1000 that doesn't have anything it can be offset with since the only other option was already offset. In other words there are duplicates.

I already have a formula that I use that will match everything that has an exact opposite match but I was wondering if there is a way to take it a step further and match items that are not exact. I put a little snapshot of different scenarios below for better explanation

Date Project Fund Amount Match
9/1/2017
P0001111
1000 -100
9/1/2017 P0001111 1000 -100
9/1/2017 P0001111 2000 100
9/1/2017 P0001111 2000 250 yes
10/23/2016 P0001111 2000 250 yes
10/23/2016 P0001111 2000 500 yes
10/23/2016 P0001111 2000 -1000 yes
10/22/2016 P0001111 2000 -1000
10/23/2016
2000 600 yes
10/23/2016 P0003244 2000 600 yes
11/12/2017 P0003244 2000 -1200 yes
11/12/2017 P0003244 2000 -1200
11/12/2017 P0003244 2000 -300
11/12/2017 P0003244 2000 150
11/12/2017
P0005555
1000 -10 yes
5/2/2016 P0005555 2000 15
5/2/2016 P0005555 1000 340 yes
5/2/2016 P0005555 1000 -105 yes
5/2/2016 P0005555 1000 -50 yes
5/2/2016 P0005555 3000 60
5/2/2016 P0005555 1000 -175 yes
5/2/2016 P0005555 3000 60
5/2/2016
P0007070
3000 -150