complex split formula to merge as per description

learn99 · Apr 2, 2018

I have a formula which looks in column K ,L and G to merge pack size description in J ,
However In G only the conversion units are extracted that is L , cl with its corresponding numbers.

However I having trouble when adding L litres corresponding for wines only , I have tried to add 1 litres but unsucessful.

Can anyone assist to correct the formula .

	F	G	H	I	J	K	L	M	X	Y

BOUTON OR CROUT.AIL&F.HERBE60G
CHABRIOR *******S NATURE 250G
PAQUITO SIROP CITRON.VRT 75CL
AIX LES BAINS EAU MIN 6X1L5
AIX LES BAINS E.MINERALE 6X1L
BROCELIANDE EAU MIN6X1L5 FARD
ONDINE E.DE SOURCE 6X1L5 1/2P
BABV BLC MANGUE E.CLUB
CHABRIOR GENOISE CITRON 150G
should read 1221L in column J
VDP CX PIN ROUGE SYRAH
VDPOC CAB.SAUV RG XPIN 37.5CL
VDP OC MERLOT RGE X PIN BIB5L
VDP CX PIN ROUGE MERLOT 75CL
GAMAY RGE CHARENTAIS 75CL
VDP CX PIN RGE CAB.SAUVIGN75CL
VDP CX DU PIN BLC CHARDONN75CL

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]CODE ARTICLE[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]DESIGNATION[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Tariff No[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Description[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: right"]Pack Size Description[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]CNDT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Qte Cndt[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]QTE UVC[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]17017154[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]19054090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]TOASTED BREAD[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]20[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]120[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]17082321[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]19059090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]BISCUITS[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]25[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]300[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]17118363[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21069060[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]SYRUP[/TD]
[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]17311278[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]105*6*1.5L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]17311280[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]39*6*1L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]17314311[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]104*6*1.5L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]17314605[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]56*6*1.5L[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]17330954[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*1*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]41027155[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]19053100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]BISCUITS[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]52335060[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]VIN ESPAGNE BLC MOELCALISSOU1L[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]WINES[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]12*2*75CL[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]24[/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]52337011[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*14*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]52337025[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]12*5*37.5CL[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]52337073[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]4*12*75CL[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]52337077[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*39*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]234[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]52337300[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]12*3*75CL[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]52337602[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*43*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]258[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]52338041[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

SPLIT SPIRITS (2)

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J2[/TH]
[TD="align: left"]=IF(LEFT(H2)="2",IF(I2="WINES",K2&"*"&L2&"*"&IF(ISNUMBER(FIND(37.5,G2)),"37.5CL","75CL"),IF(U2="*",M2&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G2,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2))-2),{1,2,3}))&"*",K2&"*"&L2&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J3[/TH]
[TD="align: left"]=IF(LEFT(H3)="2",IF(I3="WINES",K3&"*"&L3&"*"&IF(ISNUMBER(FIND(37.5,G3)),"37.5CL","75CL"),IF(U3="*",M3&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G3,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G3))-2),{1,2,3}))&"*",K3&"*"&L3&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G3),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J4[/TH]
[TD="align: left"]=IF(LEFT(H4)="2",IF(I4="WINES",K4&"*"&L4&"*"&IF(ISNUMBER(FIND(37.5,G4)),"37.5CL","75CL"),IF(U4="*",M4&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G4,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G4))-2),{1,2,3}))&"*",K4&"*"&L4&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G4),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J5[/TH]
[TD="align: left"]=IF(LEFT(H5)="2",IF(I5="WINES",K5&"*"&L5&"*"&IF(ISNUMBER(FIND(37.5,G5)),"37.5CL","75CL"),IF(U5="*",M5&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G5,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G5))-2),{1,2,3}))&"*",K5&"*"&L5&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G5),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J6[/TH]
[TD="align: left"]=IF(LEFT(H6)="2",IF(I6="WINES",K6&"*"&L6&"*"&IF(ISNUMBER(FIND(37.5,G6)),"37.5CL","75CL"),IF(U6="*",M6&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G6,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G6))-2),{1,2,3}))&"*",K6&"*"&L6&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G6),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J7[/TH]
[TD="align: left"]=IF(LEFT(H7)="2",IF(I7="WINES",K7&"*"&L7&"*"&IF(ISNUMBER(FIND(37.5,G7)),"37.5CL","75CL"),IF(U7="*",M7&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G7,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G7))-2),{1,2,3}))&"*",K7&"*"&L7&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G7),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J8[/TH]
[TD="align: left"]=IF(LEFT(H8)="2",IF(I8="WINES",K8&"*"&L8&"*"&IF(ISNUMBER(FIND(37.5,G8)),"37.5CL","75CL"),IF(U8="*",M8&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G8,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G8))-2),{1,2,3}))&"*",K8&"*"&L8&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G8),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J9[/TH]
[TD="align: left"]=IF(LEFT(H9)="2",IF(I9="WINES",K9&"*"&L9&"*"&IF(ISNUMBER(FIND(37.5,G9)),"37.5CL","75CL"),IF(U9="*",M9&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G9,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G9))-2),{1,2,3}))&"*",K9&"*"&L9&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G9),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J10[/TH]
[TD="align: left"]=IF(LEFT(H10)="2",IF(I10="WINES",K10&"*"&L10&"*"&IF(ISNUMBER(FIND(37.5,G10)),"37.5CL","75CL"),IF(U10="*",M10&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G10,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G10))-2),{1,2,3}))&"*",K10&"*"&L10&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G10),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J11[/TH]
[TD="align: left"]=IF(LEFT(H11)="2",IF(I11="WINES",K11&"*"&L11&"*"&IF(ISNUMBER(FIND(37.5,G11)),"37.5CL","75CL"),IF(U11="*",M11&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G11,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G11))-2),{1,2,3}))&"*",K11&"*"&L11&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G11),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J12[/TH]
[TD="align: left"]=IF(LEFT(H12)="2",IF(I12="WINES",K12&"*"&L12&"*"&IF(ISNUMBER(FIND(37.5,G12)),"37.5CL","75CL"),IF(U12="*",M12&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G12,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G12))-2),{1,2,3}))&"*",K12&"*"&L12&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G12),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J13[/TH]
[TD="align: left"]=IF(LEFT(H13)="2",IF(I13="WINES",K13&"*"&L13&"*"&IF(ISNUMBER(FIND(37.5,G13)),"37.5CL","75CL"),IF(U13="*",M13&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G13,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G13))-2),{1,2,3}))&"*",K13&"*"&L13&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G13),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J14[/TH]
[TD="align: left"]=IF(LEFT(H14)="2",IF(I14="WINES",K14&"*"&L14&"*"&IF(ISNUMBER(FIND(37.5,G14)),"37.5CL","75CL"),IF(U14="*",M14&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G14,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14))-2),{1,2,3}))&"*",K14&"*"&L14&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J15[/TH]
[TD="align: left"]=IF(LEFT(H15)="2",IF(I15="WINES",K15&"*"&L15&"*"&IF(ISNUMBER(FIND(37.5,G15)),"37.5CL","75CL"),IF(U15="*",M15&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G15,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G15))-2),{1,2,3}))&"*",K15&"*"&L15&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G15),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J16[/TH]
[TD="align: left"]=IF(LEFT(H16)="2",IF(I16="WINES",K16&"*"&L16&"*"&IF(ISNUMBER(FIND(37.5,G16)),"37.5CL","75CL"),IF(U16="*",M16&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G16,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G16))-2),{1,2,3}))&"*",K16&"*"&L16&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G16),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J17[/TH]
[TD="align: left"]=IF(LEFT(H17)="2",IF(I17="WINES",K17&"*"&L17&"*"&IF(ISNUMBER(FIND(37.5,G17)),"37.5CL","75CL"),IF(U17="*",M17&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G17,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G17))-2),{1,2,3}))&"*",K17&"*"&L17&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G17),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J18[/TH]
[TD="align: left"]=IF(LEFT(H18)="2",IF(I18="WINES",K18&"*"&L18&"*"&IF(ISNUMBER(FIND(37.5,G18)),"37.5CL","75CL"),IF(U18="*",M18&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G18,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G18))-2),{1,2,3}))&"*",K18&"*"&L18&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G18),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

asakhy · Apr 2, 2018

Hi learn99,
I used the same formula that you had used, and I am getting the J4 and J5 values as 6*5*75CL and 1*105*1.5L respectively. Which excel version are you using???[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

learn99 · Apr 2, 2018

Hi

See attached link to file .

when there is water or other canned products coulumn U and V , there is an asterisk and a manual imput to check if data is correct.

Worked on Excel 2007 (work) and excel 2016 (home)

https://drive.google.com/file/d/1cv9H_OG0XwmUtGhq2rcDuRQqZZxdu6PF/view?usp=sharing

asakhy · Apr 2, 2018

how about the designation in G column:
[TABLE="width: 299"]
<tbody>[TR]
[TD="width: 299"]BABV BLC MANGUE E.CLUB
[TABLE="width: 299"]
<tbody>[TR]
[TD="width: 299"]VDP CX PIN ROUGE SYRAH
[TABLE="width: 299"]
<tbody>[TR]
[TD="class: xl68, width: 299"]VDP OC MERLOT RGE X PIN BIB5L

What about the Description here - since in first 2, nothing is mentioned, while for third one, it says 5L[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

asakhy · Apr 2, 2018

Use the following formula in place of the existing formula:

=IF(LEFT(H14)="2",IF(I14="WINES",K14&"*"&L14&"*"&IF(ISNUMBER(FIND(37.5,G14)),"37.5CL",IF(ISNUMBER(FIND("75CL",G14)),"75CL",IF(ISNUMBER(FIND("1L5",G14)),"1.5L",IF(ISNUMBER(FIND("1L",G14)),"1L","75CL")))),IF(U14="*",M14&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G14,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14))-2),{1,2,3}))&"*",K14&"*"&L14&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")

learn99 · Apr 3, 2018

I have used your formula , we are on the right track the wines with blank should be taken automatic 75CL by default.

I have tested on 1.5L, 2L,3L, 5 L ,need to adjust accordingly

however I notice that beer where they are 3*25cl , it should be taken M only , this was done previously by adding * in column U , it automatically adjust accordingly , this also applies for mineral water .

I have attached a link with full for ease of understanding

https://drive.google.com/file/d/1Mo0XPKo5g7jian4iNLbgHBe7uBtznAa0/view?usp=sharing

but need some adjustments on mineral water , beer and wines when there are no litrages , then take default 75 vl

	A	E	F	G
Checking
AAA	BOUTON OR CROUT.AIL&F.HERBE60G	TOASTED BREAD	3.25039E+12
AAA	BOUTON DOR CROUTONS SALADE 60G	TOASTED BREAD
AAA	KINGSBRAU TEKIROS BTE 50CL	BEER
AAA	CHAB PT BEURRE PEP CHOCO 200G	BISCUITS
AAA	CHAB MINI GOUT.FOUR.CHOCO 168G	BISCUITS
AAA	ST.EMILION GC RG EXPERT CLUB75	WINES
AAA	BLAYE CTE BORDEAUX RG EXP.CLUB	WINES	WRONG
AAA	CHABRIOR CEREALES JUNGLE 400G	PREPARED CEREAL
AAA	CHABRIOR SPECULOOS 250G	BISCUITS
AAA	CHABRIOR TH CHOCO/BLANC 150G	BISCUITS
AAA	BDX SUP RGE HAUSSMANN B.EUGENE	WINES	WRONG
AAA	BOUTON D'OR NOIX DE PECAN 100G	PREPARED NUTS	WRONG SHOULD BE BLANK
AAA	BOUTON OR STICKS&BRETZELS 300G	SNACKS
AAA	CHAB SABLES FOURRES CACAO 125G	BISCUITS
AAA	CHAB SABLE FOURRE NOISETTE 125	BISCUITS
AAA	CHAB BRIEFING CHOCO BLANC 150	BISCUITS
AAA	BO CRUSTY NUT CCH SALEES 125G	PREPARED NUTS	WRONG SHOULD BE BLANK
AAA	CHABRIOR *******S NATURE 250G	BISCUITS
AAA	CHAB TURBULO CHOCO NOIR 200G	BISCUITS
AAA	MUSCADET S&M LIE HT-BANCHE.75C	WINES
AAA	CHAB TART.CARR.CHOCO/NOIS 127G	BISCUITS
AAA	CHAB TART.CARREE FRAISE 127G	BISCUITS
AAA	ON OFF ****T.COSMOPOLIT.15D 70	LIQUEURS
AAA	PAQUITO BIO SIR.GRENADINE 50CL	SYRUP	6350CL
AAA	PAQUITO BIO SIROP MENTHE 50CL	SYRUP	6350CL
AAA	CHAB GALET.PEPI.CHOCOLAT 130G	BISCUITS
AAA	ABBAY LEFFE NECTAR 6X25CL	BEER	WRONG
AAA	PAQUITO SIROP CITRON.VRT 75CL	SYRUP	6575CL
AAA	CHAB PE**** BEURRE BIO 200G	BISCUITS
AAA	CHAB BISCOTTES COMPLETES 300G	BISCUITS
AAA	CHABRIOR BOUDOIRS 175G	BISCUITS
AAA	ST.EM RG LEO LA GAFFELIERE 75	WINES
AAA	BORDEAUX BL MOUTON CADET	WINES
AAA	CHAB.PT.PAIN GRIL.7CER.BIO225G	TOASTED BREAD
AAA	ON OFF ****T. S/ALC.PECHE 75CL	FRUIT JUICE
AAA	ON OFF ****T.S/ALC.PLANTEUR 75	FRUIT JUICE
AAA	CHAB.PT.PAIN GRILLE.6CEREAL225	TOASTED BREAD
AAA	BABV BLC PECHE EXPERT.CLUB	WINES	WRONG
AAA	BABV RSE PAMPL EXP CLUB	WINES	WRONG
AAA	CHABRIOR PETIT LAIT 200G	BISCUITS
AAA	O.OFF CITRO.VERT/KIWI S/ALC.75	FRUIT JUICE
AAA	CTE BERGERAC BL MOELL EXP CLUB	WINES	WRONG
AAA	ON OFF MOJITO ****T.15D 70CL	LIQUEURS
AAA	ON OFF LIQUEUR LITCHI 15D 70CL	LIQUEURS
AAA	ON OFF LIQUE. SO COCO 18D 70CL	LIQUEURS
AAA	BO *******S GOUT EMMENTAL 105G	BISCUIT *******S
AAA	BO *******S SESAME/PAVOT 100G	BISCUIT *******S
AAA	BO *******S GOUT PIZZA 85G	BISCUIT *******S
AAA	BO MINI FLUTE FEUIL.EMMENT.125	BAKERIES
AAA	ON OFF SO MINT 18D 70CL	LIQUEURS
AAA	ON OFF SO MANZANA 18D 70 CL	LIQUEURS
AAA	BO NOIX DE CAJOU SANS SEL 125G	PREPARED NUTS
AAA	AOC BDX SUPP RGE BOISE E.C	WINES	???
AAA	PAQUITO ****TAIL MOJITO BOC 1L	FRUIT JUICE
AAA	CHAB GATEAU TOUT CHOCO 300G	BAKERIES
AAA	CINS.GRENACHE RS E.CLUB 37.5CL	WINES	12337.5CL
AAA	BABV SANGRIA ROSE SOLARIA	WINES	6375CL	WRONG
AAA	CHAB TWISTY CHOCOLAT LAIT 90G	BAKERIES
AAA	AIX LES BAINS EAU MIN 6X1L5	MINERAL WATER	10561L5	WRONG
AAA	AIX LES BAINS E.MINERALE 6X1L	MINERAL WATER	3961L	WRONG
AAA	BROCELIANDE EAU MIN6X1L5 FARD	MINERAL WATER	10461L5	WRONG
AAA	ONDINE E.DE SOURCE 6X1L5 1/2P	MINERAL WATER	5661L5	WRONG
AAA	BABV BLC MANGUE E.CLUB	WINES	6175CL	WRONG
AAA	CHAB ROLL'CREAMY CHOC 154G	BISCUITS
AAA	BABV BLC CITRON EXPERT CLUB	WINES	6475CL
AAA	BABV RSE FRAMBOISE EX.CLUB	WINES	6375CL
AAA	ON OFF CAIPIRINHA 15D 70 CL	LIQUEURS
AAA	CHAB.BISCUITS SESAME BIO 180G	TOASTED BREAD
AAA	LES CREAT. BISC MERING.CAFE100	BISCUITS
AAA	LES CREAT. BISC MERING.CHOC90G	BISCUITS
AAA	BO.MELANGE DU SOLEIL 120G	PREPARED FRUITS	WRONG
AAA	CHAB.BISCUIT AMAN/CIT BIO 200G	BISCUITS
AAA	CHABRIOR SABLES CAFE 120G	BISCUITS
AAA	CHAB PT PAIN GRIL.NAT BIO 225G	TOASTED BREAD
AAA	BOUTON OR AMANDE CHILI 100G	MIXED NUTS PREPARATION
AAA	CHA.TARTELETTE ROND.ABRIC 150G	BISCUITS
AAA	PATURAGES CREME DESS.VANIL.510	TOPPINGS	WRONG
AAA	KINGSBRAU BIERE PREMIUM 50CL	BEER
AAA	CHABRIOR CRACK'N GOLD 375G	CEREALS
AAA	BO.*******S ALL.OLIV ORIGAN100	*******S
AAA	PAQUITO ICED TEA PECHE 75CL	ICE TEA
AAA	ON OFF MANGUE PASS.LIQ.15D 70C	LIQUEURS
AAA	CHAB TARTELET.RDES FRAISE 150G	BISCUITS
AAA	CHABRIOR TH CREAMY CHOC 115G	BISCUITS
AAA	CHAB GOUTER CROK VANILLE 300G	BISCUITS
AAA	ST ELOI CROUTONS NATURE 90G X2	TOASTED BREAD
AAA	PAQUITO ZERO SUCRE CITRON 75CL	SYRUP	6775CL
AAA	CHAB.BISCOTTE BRIOCHEE 300G	BISCOT
AAA	CHAB.BISC.CREAMY CHOC 165G	BISCUITS
AAA	CHAB MUESLI CRISPY CHOCOLT 500	MUESLI CEREALS
AAA	CHAB PT DEJ MULTI CEREAL400G	MUESLI CEREALS
AAA	BO.MELANGE FTS RGES/AMAND.120G	PREPARED NUTS	WRONG
AAA	GAILLAC RSE LES 3 ORMEAUX	WINES	61075CL	WRONG
AAA	IDS TORTILA CHIP MEXIC400G	SNACKS
AAA	IDS TORTILLA CHIP NAT 400G	SNACKS
AAA	CHABRIOR BISCOTTES 36TR 300G	BISCOT
AAA	CHABRIOR BISCOT 36T CEREAL300G	BISCOT
AAA	TOP BUDGET BISCOTTES 1KG	BISCOT
AAA	CHABRIOR BISCOTTES S/SEL 300G	BISCOT

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]INVOICE NO[/TD]
[TD="align: center"]fff[/TD]
[TD="align: center"]CODE ARTICLE[/TD]
[TD="align: center"]DESIGNATION[/TD]
[TD="align: center"]Tariff No[/TD]
[TD="align: center"]Description[/TD]
[TD="align: right"]Pack Size Description[/TD]
[TD="align: center"]CNDT[/TD]
[TD="align: center"]Qte Cndt[/TD]
[TD="align: center"]QTE UVC[/TD]
[TD="align: center"]header18[/TD]
[TD="align: center"]header24[/TD]
[TD="align: center"][/TD]
[TD="align: right"]expected results[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17017154[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"][/TD]

[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17017157[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]22030001[/TD]
[TD="align: right"]17020032[/TD]

[TD="align: right"]22030011[/TD]

[TD="align: right"]24*4*50CL[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]24*4*50CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]19053130[/TD]
[TD="align: right"]17023165[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]105*6*1.5L[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]19053191[/TD]
[TD="align: right"]17023168[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]39*6*1L[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]22042142[/TD]
[TD="align: right"]17023249[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]6*4*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]6*4*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]22042142[/TD]
[TD="align: right"]17023312[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]6*9*75CL[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]19041030[/TD]
[TD="align: right"]17023388[/TD]

[TD="align: right"]19042000[/TD]

[TD="align: right"][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]6*1*75CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17026438[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]19053119[/TD]
[TD="align: right"]17026442[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]216[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]12*2*1L[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]22042142[/TD]
[TD="align: right"]17026941[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*4*75CL[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17031153[/TD]

[TD="align: right"]20081190[/TD]

[TD="align: right"]18*16*100CL[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]288[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]12*5*37.5CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]19059045[/TD]
[TD="align: right"]17031156[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4*12*75CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17036404[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*39*75CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17036405[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]180[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]12*3*75CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]19053119[/TD]
[TD="align: right"]17047017[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*43*75CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]20081196[/TD]
[TD="align: right"]17069815[/TD]

[TD="align: right"]20081190[/TD]

[TD="align: right"]27*6*25CL[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]162[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]19054090[/TD]
[TD="align: right"]17082321[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]19053119[/TD]
[TD="align: right"]17082659[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]440[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]22042117[/TD]
[TD="align: right"]17088420[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]6*3*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*3*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17088449[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]234[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17088457[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]198[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17105867[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*9*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*9*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17109134[/TD]

[TD="align: right"]21069060[/TD]

[TD="align: right"]6*3*50CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17109139[/TD]

[TD="align: right"]21069060[/TD]

[TD="align: right"]6*3*50CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"]19053130[/TD]
[TD="align: right"]17109867[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]288[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"]22030001[/TD]
[TD="align: right"]17118212[/TD]

[TD="align: right"]22030019[/TD]

[TD="align: right"]4*8*25CL[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]32*6*25CL[/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]29[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17118363[/TD]

[TD="align: right"]21069060[/TD]

[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]19053130[/TD]
[TD="align: right"]17142381[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"]19054010[/TD]
[TD="align: right"]17143747[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17144036[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]322[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]

[TD="align: right"]22042142[/TD]
[TD="align: right"]17144067[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]6*7*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*7*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]

[TD="align: right"]22042112[/TD]
[TD="align: right"]17144130[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*7*75CL[/TD]
[TD="align: right"]#N/A[/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17144305[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]

[TD="align: right"]21069059[/TD]
[TD="align: right"]17145347[/TD]

[TD="align: right"]22021091[/TD]

[TD="align: right"]6*13*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*13*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]

[TD="align: right"]21069059[/TD]
[TD="align: right"]17145355[/TD]

[TD="align: right"]22021091[/TD]

[TD="align: right"]6*10*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*10*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17152226[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]

[TD="align: right"]22042179[/TD]
[TD="align: right"]17169695[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*3*75CL[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]40[/TD]

[TD="align: right"]22042180[/TD]
[TD="align: right"]17169919[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*3*75CL[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]41[/TD]

[TD="align: right"]19059055[/TD]
[TD="align: right"]17171170[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]384[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]

[TD="align: right"]21069059[/TD]
[TD="align: right"]17171222[/TD]

[TD="align: right"]22021091[/TD]

[TD="align: right"]6*13*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*13*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]

[TD="align: right"]22042138[/TD]
[TD="align: right"]17171585[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]44[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17173935[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*32*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*32*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]45[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17181184[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*23*70CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*23*70CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17181185[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*29*70CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]174[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*29*70CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]47[/TD]

[TD="align: right"]19059055[/TD]
[TD="align: right"]17193760[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]176[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]48[/TD]

[TD="align: right"]19059045[/TD]
[TD="align: right"]17193765[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]49[/TD]

[TD="align: right"]19059045[/TD]
[TD="align: right"]17193781[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]50[/TD]

[TD="align: right"]19059045[/TD]
[TD="align: right"]17211057[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]51[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17212593[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*13*70CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*13*70CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]52[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17216032[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*27*70CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*27*70CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]53[/TD]

[TD="align: right"]20081991[/TD]
[TD="align: right"]17221760[/TD]

[TD="align: right"]20081190[/TD]

[TD="align: right"]36*10*25CL[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]360[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]54[/TD]

[TD="align: right"]22042142[/TD]
[TD="align: right"]17242647[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]6*7*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*7*75CL[/TD]
[TD="align: right"]TRUE[/TD]

[TD="align: center"]55[/TD]

[TD="align: right"]22029010[/TD]
[TD="align: right"]17246609[/TD]

[TD="align: right"]22021091[/TD]

[TD="align: right"]6*35*1L[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]210[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*35*1L[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]56[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17270385[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]57[/TD]

[TD="align: right"]22042180[/TD]
[TD="align: right"]17277426[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]12*3*37.5CL[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]58[/TD]

[TD="align: right"]22042148[/TD]
[TD="align: right"]17290883[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]#N/A[/TD]

[TD="align: center"]59[/TD]

[TD="align: right"]19053119[/TD]
[TD="align: right"]17301659[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]60[/TD]

[TD="align: right"]22011011[/TD]
[TD="align: right"]17311278[/TD]

[TD="align: right"]22011011[/TD]

[TD="align: right"]1*105*1.5L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]FALSE[/TD]

[TD="align: center"]61[/TD]

[TD="align: right"]22011011[/TD]
[TD="align: right"]17311280[/TD]

[TD="align: right"]22011011[/TD]

[TD="align: right"]1*39*1L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]FALSE[/TD]

[TD="align: center"]62[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17314311[/TD]

[TD="align: right"]22011011[/TD]

[TD="align: right"]1*104*1.5L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]FALSE[/TD]

[TD="align: center"]63[/TD]

[TD="align: right"]22011011[/TD]
[TD="align: right"]17314605[/TD]

[TD="align: right"]22011011[/TD]

[TD="align: right"]56*1*1.5L[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]FALSE[/TD]

[TD="align: center"]64[/TD]

[TD="align: right"]22042179[/TD]
[TD="align: right"]17330954[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]#N/A[/TD]

[TD="align: center"]65[/TD]

[TD="align: right"]19053191[/TD]
[TD="align: right"]17331300[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]66[/TD]

[TD="align: right"]22042180[/TD]
[TD="align: right"]17331710[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"][/TD]

[TD="align: center"]67[/TD]

[TD="align: right"]22042180[/TD]
[TD="align: right"]17332676[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"][/TD]

[TD="align: center"]68[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17358032[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*10*70CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*10*70CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]69[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17368785[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]70[/TD]

[TD="align: right"]19053119[/TD]
[TD="align: right"]17368967[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]71[/TD]

[TD="align: right"]19053119[/TD]
[TD="align: right"]17368971[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]72[/TD]

[TD="align: right"]20081911[/TD]
[TD="align: right"]17373192[/TD]

[TD="align: right"]20089900[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]73[/TD]

[TD="align: right"]19053130[/TD]
[TD="align: right"]17373198[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]74[/TD]

[TD="align: right"]19053291[/TD]
[TD="align: right"]17376829[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]75[/TD]

[TD="align: right"]19054090[/TD]
[TD="align: right"]17376867[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]76[/TD]

[TD="align: right"]20081993[/TD]
[TD="align: right"]17376926[/TD]

[TD="align: right"]20081190[/TD]

[TD="align: right"]18*11*100CL[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]198[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]77[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17382427[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]312[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]78[/TD]

[TD="align: right"]19019099[/TD]
[TD="align: right"]17382442[/TD]

[TD="align: right"]21069090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]79[/TD]

[TD="align: right"]22030001[/TD]
[TD="align: right"]17390415[/TD]

[TD="align: right"]22030011[/TD]

[TD="align: right"]24*5*50CL[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]24*5*50CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]80[/TD]

[TD="align: right"]19041030[/TD]
[TD="align: right"]17391100[/TD]

[TD="align: right"]19041000[/TD]

[TD="align: right"][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]81[/TD]

[TD="align: right"]19059045[/TD]
[TD="align: right"]17397475[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]82[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17403801[/TD]

[TD="align: right"]22029970[/TD]

[TD="align: right"]6*30*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]180[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*30*75CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]83[/TD]

[TD="align: right"]22087010[/TD]
[TD="align: right"]17463429[/TD]

[TD="align: right"]22087019[/TD]

[TD="align: right"]6*12*70CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*12*70CL[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]84[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17465554[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]264[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]85[/TD]

[TD="align: right"]19053199[/TD]
[TD="align: right"]17465563[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]86[/TD]

[TD="align: right"]19053191[/TD]
[TD="align: right"]17468731[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]264[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]87[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17477963[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]88[/TD]

[TD="align: right"]21069092[/TD]
[TD="align: right"]17478101[/TD]

[TD="align: right"]21069060[/TD]

[TD="align: right"]6*7*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]89[/TD]

[TD="align: right"]19054010[/TD]
[TD="align: right"]17478543[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]90[/TD]

[TD="align: right"]19053191[/TD]
[TD="align: right"]17478731[/TD]

[TD="align: right"]19053100[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]91[/TD]

[TD="align: right"]19041030[/TD]
[TD="align: right"]17484745[/TD]

[TD="align: right"]19042000[/TD]

[TD="align: right"][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]92[/TD]

[TD="align: right"]19053130[/TD]
[TD="align: right"]17485180[/TD]

[TD="align: right"]19042000[/TD]

[TD="align: right"][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]93[/TD]

[TD="align: right"]20081919[/TD]
[TD="align: right"]17501995[/TD]

[TD="align: right"]20081190[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]94[/TD]

[TD="align: right"]22042178[/TD]
[TD="align: right"]21002885[/TD]

[TD="align: right"]22041090[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]#N/A[/TD]

[TD="align: center"]95[/TD]

[TD="align: right"]19059010[/TD]
[TD="align: right"]40395050[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]228[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]96[/TD]

[TD="align: right"]19059010[/TD]
[TD="align: right"]40395052[/TD]

[TD="align: right"]19059090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]97[/TD]

[TD="align: right"]19054010[/TD]
[TD="align: right"]41011030[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]98[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]41011051[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]99[/TD]

[TD="align: right"]19054010[/TD]
[TD="align: right"]41011130[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

[TD="align: center"]100[/TD]

[TD="align: right"]19054010[/TD]
[TD="align: right"]41012010[/TD]

[TD="align: right"]19054090[/TD]

[TD="align: right"][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"][/TD]

</tbody>

SPLIT

asakhy · Apr 5, 2018

Hi learn99,
Sorry , I was occupied yesterday, hence could not check the message.
I could see that there are only 9 values where the description is given as BEER. And in those values, I could not find a 3*25CL.
Request you to kindly re-phrase the problem encountered.

Peter_SSs · Apr 5, 2018

learn99 said:
I have attached a link with full for ease of understanding

https://drive.google.com/file/d/1Mo0XPKo5g7jian4iNLbgHBe7uBtznAa0/view?usp=sharing

I am not sure that it will resolve all your problems, but that file's column J formula has a fundamental problem in that it contains an incorrect row reference. That is, the first part of the J2 formula includes a reference to row 12, not row 2

=IF(LEFT(H2)="2",IF(I12="WINES",K2&"*"&L2&"*"&IF(...

After correcting that, if you still have problems, please post (directly in your post is better than a link for now) a small set of sample data with expected results. We don't need all columns, just the relevant ones which, I think, would be G:M & U:V

asakhy · Apr 5, 2018

Peter sir,
the first part of the J2 formula includes a reference to row 12, not row 2 seems to have been by mistake , as it is applicable only to first 12 rows. After that, the formula is referring to the correct cells.

Peter_SSs · Apr 5, 2018

asakhy said:
Peter sir,
the first part of the J2 formula includes a reference to row 12, not row 2 seems to have been by mistake , as it is applicable only to first 12 rows. After that, the formula is referring to the correct cells.

Perhaps we are looking at different files? I just double-checked the link in post #6 and did not find what you described. Even the last formula (row 272) refers to cell I282

As I indicated earlier, I doubt this is the entire problem, but it would be the first thing to fix.

complex split formula to merge as per description

learn99

New Member

Excel Facts

asakhy

New Member

learn99

New Member

asakhy

New Member

asakhy

New Member

learn99

New Member

asakhy

New Member

Peter_SSs

MrExcel MVP, Moderator

asakhy

New Member

Peter_SSs

MrExcel MVP, Moderator

Forum statistics

Share this page

complex split formula to merge as per description

New Member

Excel Facts

New Member

New Member

New Member

New Member

New Member

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock