Matching the Values with different

[Lalaiah]

Hi All,

Can you please help me with logic match if we negative and positive values are zero. 

RecordID	Assigned_to_Report	PAYMENT	User_Hidden
LOT 0			23.99
LOT 1		(4,198.41)
LOT 2	3,412.79	(141.81)
LOT 3	7,148.38	(6,362.76)	141.81
LOT 4		(4,192.04)
LOT 5	4,192.04	(121.69)	243.38
LOT 6		(2,229.23)
LOT 7		(14,263.65)
LOT 8	16,492.88	(140.30)	351.49
LOT 9		(5,305.76)
LOT 10	5,233.43	(22.28)	22.28
LOT 11	72.33	(17,563.28)
LOT 12	101.44	(1,724.23)	1,660.52
LOT 13	17,206.56	(155.00)	50.19
LOT 14	255.28	(3,158.43)	13.52

and attaching the data how we manually matching.

[sudak]

Is there something that can be used to group them?  Trying to see if any combination of values on one side can be added up to where the sum matches any combination of values on the other seems not only very difficult, but also runs a risk of grouping incorrect values.   If you had, say, an invoice number in the data, you could use a summary tool to group by the invoice number and sum the two columns, then compare the two sums.   

[Lalaiah]

@sudak Thanks for the quick response!! if i grouped the mismatch amounts are missing so i am doing manually.