Proj Vs Actual

L

linga

New Member
Joined
Apr 5, 2014
Messages
40
Office Version
  1. 2013
[TABLE="width: 1021"]
<TBODY>[TR]
[TD]Week</SPAN>
[/TD]
[TD]Month</SPAN>
[/TD]
[TD]Product</SPAN>
[/TD]
[TD]Description</SPAN>
[/TD]
[TD="align: right"]Nov-13</SPAN>
[/TD]
[TD="align: right"]Dec-13</SPAN>
[/TD]
[TD="align: right"]Jan-14</SPAN>
[/TD]
[TD="align: right"]Feb-14</SPAN>
[/TD]
[TD="align: right"]Mar-14</SPAN>
[/TD]
[TD="align: right"]Apr-14</SPAN>
[/TD]
[TD="align: right"]May-14</SPAN>
[/TD]
[TD="align: right"]Jun-14</SPAN>
[/TD]
[TD="align: right"]Jul-14</SPAN>
[/TD]
[TD="align: right"]Aug-14</SPAN>
[/TD]
[TD="align: right"]Sep-14</SPAN>
[/TD]
[TD="align: right"]Oct-14</SPAN>
[/TD]
[TD="align: right"]Nov-14</SPAN>
[/TD]
[TD="align: right"]Dec-14</SPAN>
[/TD]
[/TR]
[TR]
[TD]45.2013</SPAN>
[/TD]
[TD]11.2013</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]150933</SPAN>
[/TD]
[TD="align: right"]36280</SPAN>
[/TD]
[TD="align: right"]138134</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]49.2013</SPAN>
[/TD]
[TD]12.2013</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]115204</SPAN>
[/TD]
[TD="align: right"]136075</SPAN>
[/TD]
[TD="align: right"]67368</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]01.2014</SPAN>
[/TD]
[TD]01.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]148842</SPAN>
[/TD]
[TD="align: right"]67508</SPAN>
[/TD]
[TD="align: right"]77942</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]06.2014</SPAN>
[/TD]
[TD]02.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]134364</SPAN>
[/TD]
[TD="align: right"]89192</SPAN>
[/TD]
[TD="align: right"]111286</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]10.2014</SPAN>
[/TD]
[TD]03.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]185060</SPAN>
[/TD]
[TD="align: right"]111038</SPAN>
[/TD]
[TD="align: right"]88596</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]14.2014</SPAN>
[/TD]
[TD]04.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]216127</SPAN>
[/TD]
[TD="align: right"]88720</SPAN>
[/TD]
[TD="align: right"]88802</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]19.2014</SPAN>
[/TD]
[TD]05.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]999017</SPAN>
[/TD]
[TD="align: right"]2786</SPAN>
[/TD]
[TD="align: right"]3060</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]23.2014</SPAN>
[/TD]
[TD]06.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]622260</SPAN>
[/TD]
[TD="align: right"]3894</SPAN>
[/TD]
[TD="align: right"]3334</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]27.2014</SPAN>
[/TD]
[TD]07.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]379678</SPAN>
[/TD]
[TD="align: right"]33083</SPAN>
[/TD]
[TD="align: right"]89536</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]32.2014</SPAN>
[/TD]
[TD]08.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]203879</SPAN>
[/TD]
[TD="align: right"]89554</SPAN>
[/TD]
[TD="align: right"]111290</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]36.2014</SPAN>
[/TD]
[TD]09.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]199722</SPAN>
[/TD]
[TD="align: right"]111694</SPAN>
[/TD]
[TD="align: right"]89838</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]40.2014</SPAN>
[/TD]
[TD]10.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]219225</SPAN>
[/TD]
[TD="align: right"]89454</SPAN>
[/TD]
[TD="align: right"]89584</SPAN>
[/TD]
[/TR]
[TR]
[TD]45.2014</SPAN>
[/TD]
[TD]11.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]211737</SPAN>
[/TD]
[TD="align: right"]108050</SPAN>
[/TD]
[/TR]
[TR]
[TD]49.2014</SPAN>
[/TD]
[TD]12.2014</SPAN>
[/TD]
[TD]X</SPAN>
[/TD]
[TD]Y</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]238638</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]

Based on the above data, the requirement is below:

[TABLE="width: 864"]
<TBODY>[TR]
[TD]X
[/TD]
[TD]Projected</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]138134</SPAN>
[/TD]
[TD="align: right"]67368</SPAN>
[/TD]
[TD="align: right"]77942</SPAN>
[/TD]
[TD="align: right"]111286</SPAN>
[/TD]
[TD="align: right"]88596</SPAN>
[/TD]
[TD="align: right"]88802</SPAN>
[/TD]
[TD="align: right"]3060</SPAN>
[/TD]
[TD="align: right"]3334</SPAN>
[/TD]
[TD="align: right"]89536</SPAN>
[/TD]
[TD="align: right"]111290</SPAN>
[/TD]
[TD="align: right"]89838</SPAN>
[/TD]
[TD="align: right"]89584</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Actual</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]148842 </SPAN>
[/TD]
[TD="align: right"]134364</SPAN>
[/TD]
[TD="align: right"]185060</SPAN>
[/TD]
[TD="align: right"]216127</SPAN>
[/TD]
[TD="align: right"]999017</SPAN>
[/TD]
[TD="align: right"]622260</SPAN>
[/TD]
[TD="align: right"]379678</SPAN>
[/TD]
[TD="align: right"]203879</SPAN>
[/TD]
[TD="align: right"]199722</SPAN>
[/TD]
[TD="align: right"]219225</SPAN>
[/TD]
[TD="align: right"]211737</SPAN>
[/TD]
[TD="align: right"]238638</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Hi, this is a cheap and cheerful solution. the formulas need to be dragged across under each used column.

The solution uses the column number to work out the row with the data in it.


Excel 2013
ABCDEFGHIJKLMNOPQR
1WeekMonthProductDescriptionNov-13Dec-13Jan-14Feb-14Mar-14Apr-14May-14Jun-14Jul-14Aug-14Sep-14Oct-14Nov-14Dec-14
245.201311.2013XY1509333628013813400000000000
349.201312.2013XY0115204136075673680000000000
41.20141.2014XY001488426750877942000000000
56.20142.2014XY0001343648919211128600000000
610.20143.2014XY0000185060111038885960000000
714.20144.2014XY000002161278872088802000000
819.20145.2014XY0000009990172786306000000
923.20146.2014XY0000000622260389433340000
1027.20147.2014XY000000003796783308389536000
1132.20148.2014XY0000000002038798955411129000
1236.20149.2014XY0000000000199722111694898380
1340.201410.2014XY000000000002192258945489584
1445.201411.2014XY000000000000211737108050
1549.201412.2014XY0000000000000238638
16 416091381346736877942111286885968880230603334895361112908983889584
17150933115204148842134364185060216127999017622260379678203879199722219225211737238638
Sheet1
Cell Formulas
RangeFormula
E16=IFERROR(OFFSET(A$2,COLUMN()-7,4),"")
E17=IFERROR(OFFSET(A$2,COLUMN()-5,4),"")
 
Upvote 0
RickXL Sir,

i have checked the formula is working, but how the value 41609 in F16 came can u Pl guide, & also i have large data in sheet 1 & how
automatically do this computation in sheet 2. Thanks for quick response.




Regards,

Linga
 
Upvote 0
Hi,

Sorry about the 41609. That is the date in the row above in the internal Excel format!

I added the IFERROR part of the formula to prevent the formula from failing if the row did not exist. The OFFSET function can try (and fail) to read rows before row 1. It is easier to omit the IFERROR and just put the formula into the cells where it will work. You could make it foolproof but only at the expense of making the formula difficult to understand.

I have modified the formula to work on Sheet2. If inserted it into Range("C4:P5").

It now looks like this:


Excel 2013
CDEFGHIJKLMNOP
41381346736877942111286885968880230603334895361112908983889584
5150933115204148842134364185060216127999017622260379678203879199722219225211737238638
Sheet2
Cell Formulas
RangeFormula
E4=OFFSET(Sheet1!C2,COLUMN()-5,4)
E5=OFFSET(Sheet1!E2,COLUMN()-3,2)
F4=OFFSET(Sheet1!D2,COLUMN()-5,4)
F5=OFFSET(Sheet1!F2,COLUMN()-3,2)
G4=OFFSET(Sheet1!E2,COLUMN()-5,4)
G5=OFFSET(Sheet1!G2,COLUMN()-3,2)
H4=OFFSET(Sheet1!F2,COLUMN()-5,4)
H5=OFFSET(Sheet1!H2,COLUMN()-3,2)
I4=OFFSET(Sheet1!G2,COLUMN()-5,4)
I5=OFFSET(Sheet1!I2,COLUMN()-3,2)
J4=OFFSET(Sheet1!H2,COLUMN()-5,4)
J5=OFFSET(Sheet1!J2,COLUMN()-3,2)
K4=OFFSET(Sheet1!I2,COLUMN()-5,4)
K5=OFFSET(Sheet1!K2,COLUMN()-3,2)
L4=OFFSET(Sheet1!J2,COLUMN()-5,4)
L5=OFFSET(Sheet1!L2,COLUMN()-3,2)
M4=OFFSET(Sheet1!K2,COLUMN()-5,4)
M5=OFFSET(Sheet1!M2,COLUMN()-3,2)
N4=OFFSET(Sheet1!L2,COLUMN()-5,4)
N5=OFFSET(Sheet1!N2,COLUMN()-3,2)
O4=OFFSET(Sheet1!M2,COLUMN()-5,4)
O5=OFFSET(Sheet1!O2,COLUMN()-3,2)
P4=OFFSET(Sheet1!N2,COLUMN()-5,4)
P5=OFFSET(Sheet1!P2,COLUMN()-3,2)
C5=OFFSET(Sheet1!C2,COLUMN()-3,2)
D5=OFFSET(Sheet1!D2,COLUMN()-3,2)
 
Upvote 0
Rick Xl Sir,

I have checked the formula for getting the data in sheet 2, thanks for ur response & it is working fine, i want to get the data for each part no wise in sheet 2.

Regards,

linga.
 
Upvote 0
Hi,
Pl ignore my previous post.
can u explain me the formula how it works , i am new to this Offset concept in excel.
Sheet 1 data Now attached below for more than 1 Product (Column C in excel).
Now in Sheet2 what exactly i required is below actual requirement.
[TABLE="width: 1409"]
<TBODY>[TR]
[TD]Week</SPAN>[/TD]
[TD]Month</SPAN>[/TD]
[TD]Product</SPAN>[/TD]
[TD]Description</SPAN>[/TD]
[TD]Nov-13</SPAN>[/TD]
[TD]Dec-13</SPAN>[/TD]
[TD]Jan-14</SPAN>[/TD]
[TD]Feb-14</SPAN>[/TD]
[TD]Mar-14</SPAN>[/TD]
[TD]Apr-14</SPAN>[/TD]
[TD]May-14</SPAN>[/TD]
[TD]Jun-14</SPAN>[/TD]
[TD]Jul-14</SPAN>[/TD]
[TD]Aug-14</SPAN>[/TD]
[TD]Sep-14</SPAN>[/TD]
[TD]Oct-14</SPAN>[/TD]
[TD]Nov-14</SPAN>[/TD]
[TD]Dec-14</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2013</SPAN>[/TD]
[TD]11.2013</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]150933</SPAN>[/TD]
[TD]36280</SPAN>[/TD]
[TD]138133</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2013</SPAN>[/TD]
[TD]12.2013</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]115204</SPAN>[/TD]
[TD]136075</SPAN>[/TD]
[TD]67368</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]1.2014</SPAN>[/TD]
[TD]1.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]148842</SPAN>[/TD]
[TD]67508</SPAN>[/TD]
[TD]77942</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]6.2014</SPAN>[/TD]
[TD]2.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]134364</SPAN>[/TD]
[TD]89192</SPAN>[/TD]
[TD]111286</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]10.2014</SPAN>[/TD]
[TD]3.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]185060</SPAN>[/TD]
[TD]111038</SPAN>[/TD]
[TD]88596</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]14.2014</SPAN>[/TD]
[TD]4.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]216127</SPAN>[/TD]
[TD]88720</SPAN>[/TD]
[TD]88802</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]19.2014</SPAN>[/TD]
[TD]5.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]999017</SPAN>[/TD]
[TD]2786</SPAN>[/TD]
[TD]3060</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]23.2014</SPAN>[/TD]
[TD]6.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]622260</SPAN>[/TD]
[TD]3894</SPAN>[/TD]
[TD]3334</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]27.2014</SPAN>[/TD]
[TD]7.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]379678</SPAN>[/TD]
[TD]33083</SPAN>[/TD]
[TD]89536</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]32.2014</SPAN>[/TD]
[TD]8.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]203879</SPAN>[/TD]
[TD]89554</SPAN>[/TD]
[TD]111290</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]36.2014</SPAN>[/TD]
[TD]9.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]199722</SPAN>[/TD]
[TD]111694</SPAN>[/TD]
[TD]89838</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]40.2014</SPAN>[/TD]
[TD]10.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]219225</SPAN>[/TD]
[TD]89454</SPAN>[/TD]
[TD]89584</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2014</SPAN>[/TD]
[TD]11.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]211737</SPAN>[/TD]
[TD]108050</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2014</SPAN>[/TD]
[TD]12.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]238638</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2013</SPAN>[/TD]
[TD]11.2013</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]200</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2013</SPAN>[/TD]
[TD]12.2013</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]1.2014</SPAN>[/TD]
[TD]1.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]7</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]6.2014</SPAN>[/TD]
[TD]2.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]10</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]10.2014</SPAN>[/TD]
[TD]3.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD]13</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]14.2014</SPAN>[/TD]
[TD]4.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]14</SPAN>[/TD]
[TD]16</SPAN>[/TD]
[TD]18</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]19.2014</SPAN>[/TD]
[TD]5.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD]19</SPAN>[/TD]
[TD]21</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]23.2014</SPAN>[/TD]
[TD]6.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]20</SPAN>[/TD]
[TD]22</SPAN>[/TD]
[TD]24</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]27.2014</SPAN>[/TD]
[TD]7.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]23</SPAN>[/TD]
[TD]25</SPAN>[/TD]
[TD]27</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]32.2014</SPAN>[/TD]
[TD]8.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]26</SPAN>[/TD]
[TD]28</SPAN>[/TD]
[TD]30</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]36.2014</SPAN>[/TD]
[TD]9.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]29</SPAN>[/TD]
[TD]31</SPAN>[/TD]
[TD]33</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]40.2014</SPAN>[/TD]
[TD]10.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]32</SPAN>[/TD]
[TD]34</SPAN>[/TD]
[TD]36</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2014</SPAN>[/TD]
[TD]11.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]35</SPAN>[/TD]
[TD]37</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2014</SPAN>[/TD]
[TD]12.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD]38</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL></COLGROUP>[/TABLE]
[TABLE="width: 1221"]
<TBODY>[TR]
[TD]Product</SPAN>[/TD]
[TD]Nov-13</SPAN>[/TD]
[TD]Dec-13</SPAN>[/TD]
[TD]Jan-14</SPAN>[/TD]
[TD]Feb-14</SPAN>[/TD]
[TD]Mar-14</SPAN>[/TD]
[TD]Apr-14</SPAN>[/TD]
[TD]May-14</SPAN>[/TD]
[TD]Jun-14</SPAN>[/TD]
[TD]Jul-14</SPAN>[/TD]
[TD]Aug-14</SPAN>[/TD]
[TD]Sep-14</SPAN>[/TD]
[TD]Oct-14</SPAN>[/TD]
[TD]Nov-14</SPAN>[/TD]
[TD]Dec-14</SPAN>[/TD]
[/TR]
[TR]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]138133</SPAN>[/TD]
[TD]67368</SPAN>[/TD]
[TD]77942</SPAN>[/TD]
[TD]111286</SPAN>[/TD]
[TD]88596</SPAN>[/TD]
[TD]88802</SPAN>[/TD]
[TD]3060</SPAN>[/TD]
[TD]3334</SPAN>[/TD]
[TD]89536</SPAN>[/TD]
[TD]111290</SPAN>[/TD]
[TD]89838</SPAN>[/TD]
[TD]89584</SPAN>[/TD]
[/TR]
[TR]
[TD]X</SPAN>[/TD]
[TD]150933</SPAN>[/TD]
[TD]115204</SPAN>[/TD]
[TD]148842</SPAN>[/TD]
[TD]134364</SPAN>[/TD]
[TD]185060</SPAN>[/TD]
[TD]216127</SPAN>[/TD]
[TD]999017</SPAN>[/TD]
[TD]622260</SPAN>[/TD]
[TD]379678</SPAN>[/TD]
[TD]203879</SPAN>[/TD]
[TD]199722</SPAN>[/TD]
[TD]219225</SPAN>[/TD]
[TD]211737</SPAN>[/TD]
[TD]238638</SPAN>[/TD]
[/TR]
[TR]
[TD]L</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD]18</SPAN>[/TD]
[TD]21</SPAN>[/TD]
[TD]24</SPAN>[/TD]
[TD]27</SPAN>[/TD]
[TD]30</SPAN>[/TD]
[TD]33</SPAN>[/TD]
[TD]36</SPAN>[/TD]
[/TR]
[TR]
[TD]L</SPAN>[/TD]
[TD]200</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD]14</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD]20</SPAN>[/TD]
[TD]23</SPAN>[/TD]
[TD]26</SPAN>[/TD]
[TD]29</SPAN>[/TD]
[TD]32</SPAN>[/TD]
[TD]35</SPAN>[/TD]
[TD]38</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=3><COL></COLGROUP>[/TABLE]


in the same way for each product the data needs to be filled
Regards,
Linga
 
Upvote 0
Hi,
Pl ignore my previous post.
can u explain me the formula how it works , i am new to this Offset concept in excel.
Sheet 1 data Now attached below for more than 1 Product (Column C in excel).
Now in Sheet2 what exactly i required is below actual requirement.
[TABLE="width: 1409"]
<TBODY>[TR]
[TD]Week</SPAN>[/TD]
[TD]Month</SPAN>[/TD]
[TD]Product</SPAN>[/TD]
[TD]Description</SPAN>[/TD]
[TD]Nov-13</SPAN>[/TD]
[TD]Dec-13</SPAN>[/TD]
[TD]Jan-14</SPAN>[/TD]
[TD]Feb-14</SPAN>[/TD]
[TD]Mar-14</SPAN>[/TD]
[TD]Apr-14</SPAN>[/TD]
[TD]May-14</SPAN>[/TD]
[TD]Jun-14</SPAN>[/TD]
[TD]Jul-14</SPAN>[/TD]
[TD]Aug-14</SPAN>[/TD]
[TD]Sep-14</SPAN>[/TD]
[TD]Oct-14</SPAN>[/TD]
[TD]Nov-14</SPAN>[/TD]
[TD]Dec-14</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2013</SPAN>[/TD]
[TD]11.2013</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]150933</SPAN>[/TD]
[TD]36280</SPAN>[/TD]
[TD]138133</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2013</SPAN>[/TD]
[TD]12.2013</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]115204</SPAN>[/TD]
[TD]136075</SPAN>[/TD]
[TD]67368</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]1.2014</SPAN>[/TD]
[TD]1.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]148842</SPAN>[/TD]
[TD]67508</SPAN>[/TD]
[TD]77942</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]6.2014</SPAN>[/TD]
[TD]2.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]134364</SPAN>[/TD]
[TD]89192</SPAN>[/TD]
[TD]111286</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]10.2014</SPAN>[/TD]
[TD]3.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]185060</SPAN>[/TD]
[TD]111038</SPAN>[/TD]
[TD]88596</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]14.2014</SPAN>[/TD]
[TD]4.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]216127</SPAN>[/TD]
[TD]88720</SPAN>[/TD]
[TD]88802</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]19.2014</SPAN>[/TD]
[TD]5.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]999017</SPAN>[/TD]
[TD]2786</SPAN>[/TD]
[TD]3060</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]23.2014</SPAN>[/TD]
[TD]6.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]622260</SPAN>[/TD]
[TD]3894</SPAN>[/TD]
[TD]3334</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]27.2014</SPAN>[/TD]
[TD]7.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]379678</SPAN>[/TD]
[TD]33083</SPAN>[/TD]
[TD]89536</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]32.2014</SPAN>[/TD]
[TD]8.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]203879</SPAN>[/TD]
[TD]89554</SPAN>[/TD]
[TD]111290</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]36.2014</SPAN>[/TD]
[TD]9.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]199722</SPAN>[/TD]
[TD]111694</SPAN>[/TD]
[TD]89838</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]40.2014</SPAN>[/TD]
[TD]10.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]219225</SPAN>[/TD]
[TD]89454</SPAN>[/TD]
[TD]89584</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2014</SPAN>[/TD]
[TD]11.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]211737</SPAN>[/TD]
[TD]108050</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2014</SPAN>[/TD]
[TD]12.2014</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]Y</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]238638</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2013</SPAN>[/TD]
[TD]11.2013</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]200</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2013</SPAN>[/TD]
[TD]12.2013</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]1.2014</SPAN>[/TD]
[TD]1.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]7</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]6.2014</SPAN>[/TD]
[TD]2.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]10</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]10.2014</SPAN>[/TD]
[TD]3.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD]13</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]14.2014</SPAN>[/TD]
[TD]4.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]14</SPAN>[/TD]
[TD]16</SPAN>[/TD]
[TD]18</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]19.2014</SPAN>[/TD]
[TD]5.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD]19</SPAN>[/TD]
[TD]21</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]23.2014</SPAN>[/TD]
[TD]6.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]20</SPAN>[/TD]
[TD]22</SPAN>[/TD]
[TD]24</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]27.2014</SPAN>[/TD]
[TD]7.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]23</SPAN>[/TD]
[TD]25</SPAN>[/TD]
[TD]27</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]32.2014</SPAN>[/TD]
[TD]8.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]26</SPAN>[/TD]
[TD]28</SPAN>[/TD]
[TD]30</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]36.2014</SPAN>[/TD]
[TD]9.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]29</SPAN>[/TD]
[TD]31</SPAN>[/TD]
[TD]33</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[/TR]
[TR]
[TD]40.2014</SPAN>[/TD]
[TD]10.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]32</SPAN>[/TD]
[TD]34</SPAN>[/TD]
[TD]36</SPAN>[/TD]
[/TR]
[TR]
[TD]45.2014</SPAN>[/TD]
[TD]11.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]35</SPAN>[/TD]
[TD]37</SPAN>[/TD]
[/TR]
[TR]
[TD]49.2014</SPAN>[/TD]
[TD]12.2014</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]Z</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD]38</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL></COLGROUP>[/TABLE]
[TABLE="width: 1221"]
<TBODY>[TR]
[TD]Product</SPAN>[/TD]
[TD]Nov-13</SPAN>[/TD]
[TD]Dec-13</SPAN>[/TD]
[TD]Jan-14</SPAN>[/TD]
[TD]Feb-14</SPAN>[/TD]
[TD]Mar-14</SPAN>[/TD]
[TD]Apr-14</SPAN>[/TD]
[TD]May-14</SPAN>[/TD]
[TD]Jun-14</SPAN>[/TD]
[TD]Jul-14</SPAN>[/TD]
[TD]Aug-14</SPAN>[/TD]
[TD]Sep-14</SPAN>[/TD]
[TD]Oct-14</SPAN>[/TD]
[TD]Nov-14</SPAN>[/TD]
[TD]Dec-14</SPAN>[/TD]
[/TR]
[TR]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]138133</SPAN>[/TD]
[TD]67368</SPAN>[/TD]
[TD]77942</SPAN>[/TD]
[TD]111286</SPAN>[/TD]
[TD]88596</SPAN>[/TD]
[TD]88802</SPAN>[/TD]
[TD]3060</SPAN>[/TD]
[TD]3334</SPAN>[/TD]
[TD]89536</SPAN>[/TD]
[TD]111290</SPAN>[/TD]
[TD]89838</SPAN>[/TD]
[TD]89584</SPAN>[/TD]
[/TR]
[TR]
[TD]X</SPAN>[/TD]
[TD]150933</SPAN>[/TD]
[TD]115204</SPAN>[/TD]
[TD]148842</SPAN>[/TD]
[TD]134364</SPAN>[/TD]
[TD]185060</SPAN>[/TD]
[TD]216127</SPAN>[/TD]
[TD]999017</SPAN>[/TD]
[TD]622260</SPAN>[/TD]
[TD]379678</SPAN>[/TD]
[TD]203879</SPAN>[/TD]
[TD]199722</SPAN>[/TD]
[TD]219225</SPAN>[/TD]
[TD]211737</SPAN>[/TD]
[TD]238638</SPAN>[/TD]
[/TR]
[TR]
[TD]L</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD]18</SPAN>[/TD]
[TD]21</SPAN>[/TD]
[TD]24</SPAN>[/TD]
[TD]27</SPAN>[/TD]
[TD]30</SPAN>[/TD]
[TD]33</SPAN>[/TD]
[TD]36</SPAN>[/TD]
[/TR]
[TR]
[TD]L</SPAN>[/TD]
[TD]200</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD]14</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD]20</SPAN>[/TD]
[TD]23</SPAN>[/TD]
[TD]26</SPAN>[/TD]
[TD]29</SPAN>[/TD]
[TD]32</SPAN>[/TD]
[TD]35</SPAN>[/TD]
[TD]38</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=3><COL></COLGROUP>[/TABLE]



in the same way for each product the above two lines only need ro be present
Regards,
Linga
 
Upvote 0
Hi,

OFFSET is described by Microsoft here: OFFSET function - Excel

Basically, it takes the cell location you give it and it adds a number to the row number of that location and also adds a column number to the column number of that location. Therefore:
=OFFSET(B5,2,2) refers to the contents of cell D7. i.e. two columns after A2 and two rows after A2.

Instead of using a constant I used a formula for the row offset which contained COLUMN(). That substitutes in the current column number. So the row it found depended on the column of the formula because the data we needed to find went down a row each time the column increased.

There are all kinds of ways of using OFFSET. The best thing to do is to have a look at the Microsoft reference above then try it out in Excel and see what your imagination can come up with.
 
Upvote 0
Hi,
One more query is, The above formula is correct only when the number of line items of each product is 14,
But in data the number of line items of each product may vary.
So if there is a change in Prodcut in data it should take the corresponding value set.
Regards,
Linga.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,247
Messages
6,171,007
Members
452,374
Latest member
keccles

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