Looking for a genius: Match Debits to Multiple Credits or vise versa

[erinfleener]

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 <colgroup><col width="64" style="width: 48pt;"> <tbody> </tbody>	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	<colgroup><col width="64" style="width: 48pt;"> <tbody> P0003244 </tbody>	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 <colgroup><col width="64" style="width: 48pt;"> <tbody> </tbody>	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 <colgroup><col width="64" style="width: 48pt;"> <tbody> </tbody>	3000	-150

<tbody>
</tbody>