Reconciliation help/formula support required

[pavanranjan]

Dear ,I need a formula for doing Reco of un-adjusted entries on daily basis for large amount of entries.

Please help me to do it with the help of excel formula .

Sample as given below :-



"Issue CN" Should be formula output :-
[TABLE="width: 636"]
<tbody>[TR]
[TD]Document of type ZCR6[/TD]
[TD]Formula Required[/TD]
[TD]Amount[/TD]
[TD]Sold to[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-247.20[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801305[/TD]
[TD][/TD]
[TD]247.20[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-456.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801181[/TD]
[TD][/TD]
[TD]456.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-13,650.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801180[/TD]
[TD][/TD]
[TD]13,650.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]Issue CN[/TD]
[TD] -15,288[/TD]
[TD]CSR0614[/TD]
[TD]un-adjusted[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-18,819.36[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801211[/TD]
[TD][/TD]
[TD]18,819.36[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-23,705.64[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801009[/TD]
[TD][/TD]
[TD]23,705.64[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-25,000.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801132[/TD]
[TD][/TD]
[TD]25,000.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD][/TD]
[TD]-38,000.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5641801132[/TD]
[TD][/TD]
[TD]38,000.00[/TD]
[TD]CSR0614[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]Issue CN[/TD]
[TD]-72,696.00[/TD]
[TD]CSR0614[/TD]
[TD]if amount are same(+ve or -ve) and unadjusted[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]Issue CN[/TD]
[TD]-72,696.00[/TD]
[TD]CSR0614[/TD]
[TD]if amount are same(+ve or -ve) and unadjusted[/TD]
[/TR]
</tbody>[/TABLE]