Matching line items for bank reconcilition : I am preparing bank reconciliation file to match the negative value with a positive one. in below table there are negative values which need to be reconciled/match with the positive one. for example A4 (5076) is the sum of negative value A2+A6+A8 (-5076) which are reconciling each other and making zero. i want a excel coding which reconcile all the positive values with the negative values. please help

A      B
1    -5425
2    -4125
3    -2632
4     5076
5    -222
6    -906
7     8279
8    -45
9    -254
10   -542

