Share register maintained on FIFO basis

K

kssoin

New Member
Joined
Nov 28, 2012
Messages
1
I have made a worksheet based on another excel file which was prepared by a Thai gentleman.The file by this gentleman is FIFOComplete.xls. The other is my file. In my file FIFO does'nt work after the second entry for out is made.
The Data Table in this file FIFOComplete is in Range R5:Q15 which in my file in range Q5:R57.
This table is created by selecting the respective range and the select what-if analysis>Data table and the selecting only the column input as the total sales ie J3 or K3. In my file this does not work.
I have not been able to find the gremlin so to say.
Perhaps someone in this forum can help me.

I realize cannot post attachments. How can attachments be enabled?
FIFOComplete

[TABLE="width: 1252"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]FIFO Cost of Inventory Outward for a002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]Inventory Inward and Outward[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total Unit Sold :[/TD]
[TD]1,40,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]From Date :[/TD]
[TD]01-10-2012[/TD]
[TD][/TD]
[TD][/TD]
[TD]Id :[/TD]
[TD]a002[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Data Table[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Num[/TD]
[TD]Date[/TD]
[TD]Id[/TD]
[TD]Units
Inward[/TD]
[TD]Unit
Cost[/TD]
[TD]Units
Outward[/TD]
[TD]Units
Balance[/TD]
[TD][/TD]
[TD]Unit Sold[/TD]
[TD]Cost of
Goods Sold[/TD]
[TD][/TD]
[TD]Num[/TD]
[TD]Date[/TD]
[TD]Units
Outward[/TD]
[TD]Total
Unit Sold[/TD]
[TD]11,80,000[/TD]
[TD]Cost of
Goods Sold[/TD]
[TD]Unit
Cost[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01-10-2012[/TD]
[TD]a001[/TD]
[TD="align: right"]50,000[/TD]
[TD]10[/TD]
[TD][/TD]
[TD="align: right"]50,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]2-10-2012[/TD]
[TD="align: right"]40,000[/TD]
[TD="align: right"]40,000[/TD]
[TD="align: right"]4,80,000[/TD]
[TD="align: right"]4,80,000[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]01-10-2012[/TD]
[TD]a002[/TD]
[TD="align: right"]40,000[/TD]
[TD]12[/TD]
[TD][/TD]
[TD="align: right"]40,000[/TD]
[TD][/TD]
[TD="align: right"]40,000[/TD]
[TD="align: right"]4,80,000[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]5-10-2012[/TD]
[TD="align: right"]1,00,000[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]7,00,000[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01-10-2012[/TD]
[TD]a001[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20,000[/TD]
[TD="align: right"]30,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]02-10-2012[/TD]
[TD]a002[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]40,000[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]03-10-2012[/TD]
[TD]a001[/TD]
[TD="align: right"]10,000[/TD]
[TD]15[/TD]
[TD="align: right"]20,000[/TD]
[TD="align: right"]20,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]04-10-2012[/TD]
[TD]a004[/TD]
[TD="align: right"]1,00,000[/TD]
[TD]5[/TD]
[TD][/TD]
[TD="align: right"]1,00,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]05-10-2012[/TD]
[TD]a002[/TD]
[TD="align: right"]1,00,000[/TD]
[TD]7[/TD]
[TD][/TD]
[TD="align: right"]1,00,000[/TD]
[TD][/TD]
[TD="align: right"]1,00,000[/TD]
[TD="align: right"]7,00,000[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]05-10-2012[/TD]
[TD]a004[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]70,000[/TD]
[TD="align: right"]30,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]05-10-2012[/TD]
[TD]a003[/TD]
[TD="align: right"]50,000[/TD]
[TD]10[/TD]
[TD][/TD]
[TD="align: right"]50,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]05-10-2012[/TD]
[TD]a002[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1,00,000[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]07-10-2012[/TD]
[TD]a001[/TD]
[TD="align: right"]70,000[/TD]
[TD]10[/TD]
[TD][/TD]
[TD="align: right"]90,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Total[/TD]
[TD][/TD]
[TD="align: right"]1,40,000[/TD]
[TD="colspan: 2"]hide these 2 columns[/TD]
[TD="align: right"]11,80,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]07-10-2012[/TD]
[TD]a001[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]80,000[/TD]
[TD="align: right"]10,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]09-10-2012[/TD]
[TD]a003[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]40,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]10-10-2012[/TD]
[TD]a003[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20,000[/TD]
[TD="align: right"]20,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]11-10-2012[/TD]
[TD]a001[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]12-10-2012[/TD]
[TD]a001[/TD]
[TD="align: right"]1,00,000[/TD]
[TD]5[/TD]
[TD][/TD]
[TD="align: right"]1,00,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]13-10-2012[/TD]
[TD]a001[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1,00,000[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]14-10-2012[/TD]
[TD]a001[/TD]
[TD="align: right"]20,000[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20,000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1,40,000[/TD]
[TD="align: right"]11,80,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

kssoinSharesFIFO_Testing.xls

[TABLE="width: 1271"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"] FIFO Cost of Shares Sold for HDFBAN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total units Sold :[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[TD]From Date :[/TD]
[TD="align: right"]20-11-2009[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Share Key :[/TD]
[TD]HDFBAN[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Data Table[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Num[/TD]
[TD]Date[/TD]
[TD]Share Id[/TD]
[TD]Shares Bought[/TD]
[TD]Price per share[/TD]
[TD]Shares Outward[/TD]
[TD]Shares balance[/TD]
[TD][/TD]
[TD]Shares Sold[/TD]
[TD]Cost of
Shares Sold[/TD]
[TD][/TD]
[TD]Num[/TD]
[TD]Date[/TD]
[TD]Shares Outward[/TD]
[TD][/TD]
[TD]Total
Shares Sold[/TD]
[TD="align: right"]132250.00[/TD]
[TD]Cost of
Shares Sold[/TD]
[TD]Price per Share[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: center"]23-12-2009[/TD]
[TD]ICSA[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]10.00[/TD]
[TD][/TD]
[TD="align: right"]2500[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]16[/TD]
[TD="align: right"]01-06-2018[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]1763.333[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10-01-2010[/TD]
[TD]ICSA[/TD]
[TD="align: right"]5500[/TD]
[TD="align: right"]15.00[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]3000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]17[/TD]
[TD="align: right"]07-07-2018[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]12-01-2016[/TD]
[TD]ICSA[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]15.00[/TD]
[TD][/TD]
[TD="align: right"]13000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]255[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]25-02-2017[/TD]
[TD]ICSA[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]10.00[/TD]
[TD][/TD]
[TD="align: right"]23000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]345[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]28-02-2017[/TD]
[TD]NTPC[/TD]
[TD="align: right"]1450[/TD]
[TD="align: right"]132.00[/TD]
[TD][/TD]
[TD="align: right"]1450[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]435[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]01-04-2017[/TD]
[TD]TATPOW[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]79.00[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]525[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]08-06-2017[/TD]
[TD]ICSA[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]13000[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]09-06-2017[/TD]
[TD]BAJFI[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]2050.00[/TD]
[TD][/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]10-12-2017[/TD]
[TD]SYMLIM[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]1250.00[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]795[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]15-12-2017[/TD]
[TD]NATPHA[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1855.00[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]885[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]19-01-2018[/TD]
[TD]BHAFOR[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]111.05[/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]975[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]25-02-2018[/TD]
[TD]HDFC[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]1750.00[/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1065[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]03-03-2018[/TD]
[TD]HDFBAN[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1500.00[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]75000.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1155[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]31-03-2018[/TD]
[TD]HDFBAN[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]1450.00[/TD]
[TD][/TD]
[TD="align: right"]75[/TD]
[TD][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]36250.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1245[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]01-04-2018[/TD]
[TD]HDFBAN[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]1400.00[/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]21000.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1335[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]01-06-2018[/TD]
[TD]HDFBAN[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]07-07-2018[/TD]
[TD]HDFBAN[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1515[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1605[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1695[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1785[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1875[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]1965[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2055[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2145[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2235[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2325[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2415[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2505[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2595[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2685[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2775[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2865[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2955[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3045[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3135[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3225[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3315[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3405[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3495[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3585[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3675[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3765[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3855[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3945[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4035[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4125[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4215[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4305[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4395[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4485[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4575[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD]#NUM![/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4665[/TD]
[TD="align: right"]132250[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]132250.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="colspan: 2"]To be hidden[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have pasted the cells of both the worksheets.
Regards.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
You must log in or register to reply here.

Similar threads

P
  • Solved
Lookup based on multiple criteria
2 3
Replies
22
Views
979
paulkc
P
C
  • Question Question
Subtotals and counta I think
Replies
1
Views
772
t0ny84
T
P
  • Solved
Computing investment return formula
Replies
8
Views
714
polarwoc
P
Asbestos_Jen
  • Solved
Speed up slow array index calculations
Replies
3
Views
122
Scott Huish
Scott Huish
E
  • Question Question
FIFO Macro giving different results each time it runs
Replies
7
Views
1K
Lee Wei Sin
L

Forum statistics

Threads
1,225,700
Messages
6,186,527
Members
453,362
Latest member
zermrodrigues

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top