Returning only one value

T

Thuynh08

New Member
Joined
Aug 17, 2011
Messages
30
Hi All,

Can someone please help me. Basically I have a material number with 2 descriptions. The one that begins with a "Z" is the deleted item. I managed to marry up the two item numbers by using Left,13 as the first 13 digits are the same. I would now like it to show only the first 13 material id and just the ONE product description. However if there is only one product description it will show that value. E.g:

Material ID: 9311783074906, Description: ZZZZZZEL 2 CUTTER-25MM##
Material ID: 931178307490601, Description: Excel 2 Cutter 25mm

End Result:
Material ID: 9311783074906, Description: Excel 2 Cutter 25mm

Any help is much appreciated many thanks :)
Thi.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
Yes the problem there is that if i use "begins with" Z. Then the material ID's that have only one description which may have a Z will not show. Eek this is all too complicated haha.

I tried using =IF(ISNUMBER(SEARCH("z",K3)),"", K3). But again there's that same problem...

Thanks anyway!
 
Upvote 0
Try this (array formulas - use Ctrl+Shift+Enter and not only Enter):

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Material ID</td><td style="font-weight: bold;;"> Description</td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;;">Material ID</td><td style="font-weight: bold;;"> Description</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">9311783074906</td><td style=";">ZZZZZZEL 2 CUTTER-25MM##</td><td style="text-align: right;;"></td><td style=";">9311783074906</td><td style=";">Excel 2 Cutter 25mm</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">931178307490601</td><td style=";">Excel 2 Cutter 25mm</td><td style="text-align: right;;"></td><td style=";">9311783074907</td><td style=";">ZZZZZZEL 2 CUTTER-25MM##02</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">9311783074907</td><td style=";">ZZZZZZEL 2 CUTTER-25MM##02</td><td style="text-align: right;;"></td><td style=";">9311783074908</td><td style=";">Excel 3 Cutter 25mm</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">931178307490801</td><td style=";">ZZZZZZEL 2 CUTTER-25MM##03</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">9311783074908</td><td style=";">Excel 3 Cutter 25mm</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D2</th><td style="text-align:left">{=IFERROR(<font color="Blue">LEFT(<font color="Red">INDEX(<font color="Green">A$2:A$6,SMALL(<font color="Purple">IF(<font color="Teal">FREQUENCY(<font color="#FF00FF">MATCH(<font color="Navy">LEFT(<font color="Blue">A$2:A$6,13</font>),A$2:A$6,0</font>),MATCH(<font color="Navy">LEFT(<font color="Blue">A$2:A$6,13</font>),A$2:A$6,0</font>)</font>)>0,ROW(<font color="#FF00FF">A$2:A$6</font>)-ROW(<font color="#FF00FF">A$2</font>)+1,2^21</font>),ROWS(<font color="Teal">D$2:D2</font>)</font>)</font>),13</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E2</th><td style="text-align:left">{=INDEX(<font color="Blue">$B$2:$B$6,MAX(<font color="Red">IF(<font color="Green">LEFT(<font color="Purple">$A$2:$A$6,13</font>)=D2,IF(<font color="Purple">SUMPRODUCT(<font color="Teal">--(<font color="#FF00FF">LEFT(<font color="Navy">$A$2:$A$6,13</font>)=D2</font>)</font>)>1,IF(<font color="Teal">LEFT(<font color="#FF00FF">$B$2:$B$6,1</font>)<>"z",ROW(<font color="#FF00FF">$B$2:$B$6</font>)-ROW(<font color="#FF00FF">$B$2</font>)+1,0</font>),ROW(<font color="Teal">$B$2:$B$6</font>)-ROW(<font color="Teal">$B$2</font>)+1</font>),0</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Markmzz
 
Upvote 0
Hi Mark,

Thank you very much for your post. You are an excel genius as well as everyone else that contributes! I have a long way to go and need my own excel mentor.
I tried your formula however it didn't work :(

The result was this: (sorry i'm not an IT genius either and can't insert the table :laugh:)

In column D:
9311783074906
9311783074906
9311783074906
Blank
Blank

In column E:
ZZZZZZEL 2 CUTTER-25MM##
ZZZZZZEL 2 CUTTER-25MM##
ZZZZZZEL 2 CUTTER-25MM##02
ZZZZZZEL 2 CUTTER-25MM##03
Excel 3 Cutter 25mm

But there is also a problem as i need all the Material ID's to have a value as in column C there are sales values. I want to basically marry up the two codes so that it will sum up the sales. I thought if i used Left(cell,13) and spit the data into a pivot table it will solve this, which it has. But now picky people only want to see one Description against the 13 digit material ID and the total sales figure below...

Thank you for your help though, much appreciated :)
Regards,
T
 
Upvote 0
Thuynh08 said:
Hi Mark,

Thank you very much for your post. You are an excel genius as well as everyone else that contributes! I have a long way to go and need my own excel mentor.
I tried your formula however it didn't work :(

The result was this: (sorry i'm not an IT genius either and can't insert the table :laugh:)

In column D:
9311783074906
9311783074906
9311783074906
Blank
Blank

In column E:
ZZZZZZEL 2 CUTTER-25MM##
ZZZZZZEL 2 CUTTER-25MM##
ZZZZZZEL 2 CUTTER-25MM##02
ZZZZZZEL 2 CUTTER-25MM##03
Excel 3 Cutter 25mm

But there is also a problem as i need all the Material ID's to have a value as in column C there are sales values. I want to basically marry up the two codes so that it will sum up the sales. I thought if i used Left(cell,13) and spit the data into a pivot table it will solve this, which it has. But now picky people only want to see one Description against the 13 digit material ID and the total sales figure below...

Thank you for your help though, much appreciated :)
Regards,
T
Click to expand...

Hi Thuynh08,

First:

You forgot to press Ctrl+Shift+Enter to enter the formula.

Do this: Type the formula and then press Ctrl+Shift+Enter and not only Enter.

Second:

To post you examples here, do the following:

Copy a small range of the cells, and paste them here.

It will help for visualization if you put borders around the cells before copy.

Finally:

Could you post a small example of what you have and a small example of what you want?

Markmzz
 
Upvote 0
Hi Markmzz,

Sincere apologies as I did not press cltr+shift+enter :eeek: . It works perfectly thank you so so much for your help :biggrin:

If I may ask for your help again that would be most appreciated.
Basically there are Value Packs for a range of products. Each value pack comprises of a number of different brushes. What I would like to do is create a report where it will take the Value Packs and divide the quantity putting the units into the corresponding brush breakdown. Please see below (i hope my copying and pasting works):

Broken Down Products
Material Product Value Packs QTY 9311783074852 9311783074838 9311783034191 9311783074920 9311783037628 9311783037611 9311783037710
9311783036140 ZZZExcel 2 Value Pack## 1 3
9311783037789 Excel Ultra Introductory Pack## 1 1 1
931178303790101 Excel Ultra Brush Pack 75mm & Slim 63mm 1 1 1
931178303791801 Excel 2 Brush Pk Bonus Slim Line 50mm## 1 2 1
931178303792501 ZZZExcel 2 Brush Pk BonUS BBQ To Wipes## 1 1
931178303807601 Excel 2 Brush 50mm 4Pk## 1 4
931178303809001 ZZZExcel 2 Brush 75mm 4Pk## 1 4
931178303810601 Excel 2 Cutter 50mm 4Pk## 1 4
931178303812001 Excel 2 Cutter 75mm 4Pk## 1 4
931178303866301 Excel 2 Brush Pk (2x75mm&1x63mm Cutter) 1 2
931178303869401 Excel 2 Brush Pack with 7 in 1 Tool 1 2

The final result I am looking for is:

Material Description QTY
9311783074852 ZZZZZZEL 2 BRUSH 75MM## 14
9311783074838 ZZZZZZEL 2 BRUSH 50MM## 4
9311783034191 ZZZZZZEL 2 CUTTER-25MM## 4
9311783074920 ZZZZZZEL 2 CUTTER-50MM## 4
9311783037628 ZZZZZZEL 2 CUTTER-75MM## 2
9311783037611 Excel Ultra Sash Cutter 50mm 2
9311783037710 Excel Ultra Sash Cutter 63mm 1

Many many thanks :)
Regards,
Tiff
 
Upvote 0
Hmm epic fail again with the pasting... Just to use one example:

9311783036140, ZZZExcel 2 Value Pack## has a quantity of 1. This value pack is comprised of 2 other products i.e 2 of 9311783074852, Excel 2 63mm & 1 of 9311783074838, Excel 2 75mm.

Therefore my final result should look like this when the data of the Value Pack is entered:

Material ID Product Descrip Quantity
9311783074852 Excel 2 63mm 2
9311783074838 Excel 2 75mm 1

Thanks again :)
 
Upvote 0
Thuynh08,

Sorry, but I didn't understand what you want.

To post you examples, do the following (don't forget to put borders around the cells):

Put borders around a small range of the cells, copy the small range of the cells and paste them here.

Like this:

<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=295><COLGROUP><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 147pt; mso-width-source: userset; mso-width-alt: 7168" width=196><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 74pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 width=99>Material ID</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 147pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=196>Description</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>9311783074906</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Excel 2 Cutter 25mm</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>9311783074907</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>ZZZZZZEL 2 CUTTER-25MM##02</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>9311783074908</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Excel 3 Cutter 25mm</TD></TR></TBODY></TABLE>

Give more information (what you have and what you want).

Markmzz
 
Upvote 0
Oh sorry I thought if I just clicked All Borders it would work. Okay so below is the data that I have for the Value Packs, in red is the brushes in each Value Pack.

<TABLE style="WIDTH: 925pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1233><COLGROUP><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4608" width=126><COL style="WIDTH: 225pt; mso-width-source: userset; mso-width-alt: 10971" width=300><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1206" width=33><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" span=4 width=111><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" span=2 width=109><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 95pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17 width=126> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 225pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=300> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=33> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 83pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=111>9311783074852</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 83pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=111>9311783074838</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 83pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=111>9311783034191</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 83pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=111>9311783074920</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 84pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=112>9311783037628</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 82pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=109>9311783037611</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; WIDTH: 82pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl111 width=109>9311783037710</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl108 height=17>Material</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl108>Value Pack</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl108>QTY</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112>Excel 2 75mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112>Excel 2 50mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112>Excel 2 75mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112>Excel 2 50mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112>Excel Ultra 75mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112> Ultra Slim 63mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112>Ultra Sash 63mm</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>9311783036140</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>ZZZExcel 2 Value Pack##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>9311783037789</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel Ultra Introductory Pack##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303790101</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel Ultra Brush Pack 75mm & Slim 63mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303791801</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel 2 Brush Pk Bonus Slim Line 50mm##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303792501</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>ZZZExcel 2 Brush Pk BonUS BBQ To Wipes##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303807601</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel 2 Brush 50mm 4Pk##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303809001</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>ZZZExcel 2 Brush 75mm 4Pk##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303810601</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel 2 Cutter 50mm 4Pk##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303812001</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel 2 Cutter 75mm 4Pk##</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl110> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303866301</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel 2 Brush Pk (2x75mm&1x63mm Cutter)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl110> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>931178303869401</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>Excel 2 Brush Pack with 7 in 1 Tool</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl110> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109> </TD></TR></TBODY></TABLE>

My end result should look like the below as it will breakdown the Value Packs to each component and sum it all up.

<TABLE style="WIDTH: 345pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=459><COLGROUP><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4608" width=126><COL style="WIDTH: 225pt; mso-width-source: userset; mso-width-alt: 10971" width=300><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1206" width=33><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; WIDTH: 95pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 height=17 width=126>Material</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; WIDTH: 225pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 width=300>Product</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; WIDTH: 25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 width=33>QTY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17>9311783074852</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105>Excel 2 75mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 align=right>14</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17>9311783074838</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105>Excel 2 50mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 align=right>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17>9311783034191</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105>Excel 2 75mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 align=right>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17>9311783074920</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105>Excel 2 50mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 align=right>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17>9311783037628</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105>Excel Ultra 75mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 align=right>2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl107 height=17>9311783037611</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl108> Ultra Slim 63mm</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl110 align=right>2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 height=17>9311783037710</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105>Ultra Sash 63mm</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl109 align=right>1</TD></TR></TBODY></TABLE>

Sorry to frustrate you. Please advise if you need further clarity...

Thanks,
T
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
VBA InputBox without entry quitting Sub/Macro
Replies
1
Views
548
Micron
M
M
  • Solved
Sum only the unique values from one column within a range of duplicate values from another column
Replies
7
Views
331
MARZIOTULLIO
M
trishcollins
  • Question Question
Find and filter on two different unique values
Replies
5
Views
216
trishcollins
trishcollins
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
498
Akuini
Akuini
C
  • Solved
Index match function
Replies
3
Views
737
Alex Blakenburg
A

Forum statistics

Threads
1,224,584
Messages
6,179,693
Members
452,938
Latest member
babeneker

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