syedibrahim_a
New Member
- Joined
- Mar 9, 2010
- Messages
- 3
<table style="width: 497pt; border-collapse: collapse;" x:str="" border="0" cellpadding="0" cellspacing="0" width="658"><colgroup><col style="width: 18pt;" width="24"><col style="width: 37pt;" width="49"><col style="width: 43pt;" width="57"><col style="width: 41pt;" span="2" width="54"><col style="width: 19pt;" width="25"><col style="width: 36pt;" width="48"><col style="width: 43pt;" width="57"><col style="width: 54pt;" width="72"><col style="width: 41pt;" width="54"><col style="width: 62pt;" span="2" width="82"></colgroup><tbody><tr style="height: 12pt;" height="16"><td style="border-width: 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext black windowtext windowtext; background-color: rgb(153, 51, 0); width: 180pt; height: 12pt;" class="xl46" colspan="5" height="16" width="238">COMPANY A</td><td style="border-width: 1pt 1pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext black windowtext windowtext; background-color: black; width: 193pt;" class="xl43" colspan="5" width="256">COMPANY Z</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent; width: 62pt;" class="xl25" width="82">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent; width: 62pt;" class="xl25" width="82">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 1pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl39" height="16">DOC</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DOC NO</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DATE</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DEBIT</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" align="left" valign="top"><v:shape style="z-index: 1; position: absolute; margin-top: 12pt; width: 113.25pt; height: 31.5pt; margin-left: 40.5pt;" id="_x0000_s1026" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" filled="f" path="m,23hdc20,20,9,23,32,13,44,8,67,10,80,9,116,,153,7,189,11v13,3,26,6,39,9c229,22,231,25,231,25v-1,6,-4,11,-4,17hae" coordsize="231,42"><vath arrowok="t"></vath></v:shape><table cellpadding="0" cellspacing="0"><tbody><tr><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent; width: 41pt; height: 12pt;" class="xl41" height="16" width="54">CREDIT</td></tr></tbody></table></td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl39">DOC</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DOC NO</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DATE</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DEBIT</td><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl41">CREDIT</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl42">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl42">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent; height: 12pt;" class="xl29" height="16">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">A</td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl30">B</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl29">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">A</td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl30">B</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl26">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl26">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00018</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="240">240.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00001</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40179" align="right">1/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="42">42.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00019</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="42">42.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00004</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40179" align="right">1/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="240">240.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00020</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="76">76.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00003</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40179" align="right">1/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="42">42.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00023</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="42">42.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00002</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="667">667.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00023</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="667">667.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="0">- </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00003</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="535">535.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00025</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="38">38.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00004</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="200">200.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00026</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="106">106.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00006</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="64">64.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00011</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="438">438.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="0">- </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">WJ</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00001</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="1">1.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00020</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="200">200.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="0">- </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00008</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="206">206.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="border-width: medium 0.5pt 1pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12.75pt;" class="xl36" height="17">US</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl37">0/00021</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl38" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl53" x:num="536">536.00 </td><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl50" x:num="0">- </td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl36">US</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl37">0/00009</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl38" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl56" x:num="51">51.00 </td><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl57" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl35" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl58">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl58">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl58">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl31" colspan="5" height="16">I want to have look up function as:</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl28" x:num="" height="16">1</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24" colspan="8">Debit(A) of company A, should match with Credit(B) of company Z</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" colspan="12" height="16">Then I will filter records only matching in both company and then I shall delete it to get the unmatched records.</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" colspan="4" height="16">Please I badly need a help.
{moderator note:email address removed}
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr></tbody></table>
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent; width: 62pt;" class="xl25" width="82">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 1pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl39" height="16">DOC</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DOC NO</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DATE</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DEBIT</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" align="left" valign="top"><v:shape style="z-index: 1; position: absolute; margin-top: 12pt; width: 113.25pt; height: 31.5pt; margin-left: 40.5pt;" id="_x0000_s1026" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" filled="f" path="m,23hdc20,20,9,23,32,13,44,8,67,10,80,9,116,,153,7,189,11v13,3,26,6,39,9c229,22,231,25,231,25v-1,6,-4,11,-4,17hae" coordsize="231,42"><vath arrowok="t"></vath></v:shape><table cellpadding="0" cellspacing="0"><tbody><tr><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent; width: 41pt; height: 12pt;" class="xl41" height="16" width="54">CREDIT</td></tr></tbody></table></td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl39">DOC</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DOC NO</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DATE</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl40">DEBIT</td><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl41">CREDIT</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl42">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl42">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent; height: 12pt;" class="xl29" height="16">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">A</td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl30">B</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl29">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">
</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl27">A</td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext; background-color: transparent;" class="xl30">B</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl26">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl26">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00018</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="240">240.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00001</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40179" align="right">1/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="42">42.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00019</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="42">42.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00004</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40179" align="right">1/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="240">240.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00020</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="76">76.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00003</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40179" align="right">1/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="42">42.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00023</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="42">42.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00002</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="667">667.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00023</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="667">667.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="0">- </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00003</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="535">535.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00025</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="38">38.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00004</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="200">200.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">UP</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00026</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="106">106.00 </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00006</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="64">64.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00011</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="438">438.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="0">- </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">WJ</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00001</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="0">- </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="1">1.00 </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12pt;" class="xl32" height="16">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00020</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl52" x:num="200">200.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl49" x:num="0">- </td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl32">US</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl33">0/00008</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl34" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl54" x:num="206">206.00 </td><td style="border-width: medium 1pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl55" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="border-width: medium 0.5pt 1pt 1pt; border-style: none solid solid; border-color: windowtext; background-color: transparent; height: 12.75pt;" class="xl36" height="17">US</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl37">0/00021</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl38" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(150, 150, 150);" class="xl53" x:num="536">536.00 </td><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl50" x:num="0">- </td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl36">US</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl37">0/00009</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl38" x:num="40210" align="right">2/1/2010</td><td style="border-width: medium 0.5pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl56" x:num="51">51.00 </td><td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: windowtext; background-color: rgb(153, 204, 255);" class="xl57" x:num="0">- </td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl35" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl35">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl51">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl58">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl58">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl58">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl31" colspan="5" height="16">I want to have look up function as:</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl28" x:num="" height="16">1</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24" colspan="8">Debit(A) of company A, should match with Credit(B) of company Z</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" colspan="12" height="16">Then I will filter records only matching in both company and then I shall delete it to get the unmatched records.</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" height="16">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr><tr style="height: 12pt;" height="16"><td style="border: medium none rgb(236, 233, 216); background-color: transparent; height: 12pt;" class="xl24" colspan="4" height="16">Please I badly need a help.
{moderator note:email address removed}
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;" class="xl24">
</td></tr></tbody></table>
Last edited by a moderator: