Search list of "text strings" for *text*, results in drop down box

J

jezscott

New Member
Joined
Feb 4, 2009
Messages
13
This question is based on the same list of information as my previous post ...which had no replies, but I eventually figured it out :-)

I'd like to be able to create a drop down box (validation list) that shows search results based on text entered in another cell.

So if I enter into a cell: *glass*

Then the drop down box would list the following:
L22106 - Greenhouses, glasshouses
L3343 - Glassfibre tendons
L6122 - Glass aggregate, expanded
L6332 - Glass
L6613 - Glass sheets
L6613131 - Stained glass
L6613132 - Engraved glass
etc.

My current validation list source formula is:
=OFFSET(TblLd,MATCH(Elem0S,TblLd,0)-1,2,COUNTIF(TblLd,Elem0S),1)
TblLd = Description Column of Table L
Elem0S = Cell where text is entered for search

This is supposed to search Column TblLd for the text in Elem0S and offset the displayed result from the column Combined.

I'd like the formula to display the same results as the criteria button in the Form box. However, strangely my formula returns the same number of results as the Form box, but only some of them are correct.

Here is an extract of one of the tables:

<table style="border-collapse: collapse; width: 709pt;" border="0" cellpadding="0" cellspacing="0" width="944"><col style="width: 56pt;" width="74"> <col style="width: 56pt;" width="75"> <col style="width: 173pt;" width="230"> <col style="width: 47pt;" width="62"> <col style="width: 377pt;" width="503"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="border-style: solid; border-color: rgb(79, 129, 189); border-width: 0.5pt 0.5pt 1pt; height: 15pt; width: 56pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" height="20" width="74">Order</td> <td class="xl69" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 56pt; font-size: 11pt; color: blue; font-weight: 700; text-decoration: none; font-family: Calibri;" width="75">Element</td> <td class="xl70" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 173pt; font-size: 11pt; color: blue; font-weight: 700; text-decoration: none; font-family: Calibri;" width="230">Description</td> <td class="xl68" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 47pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="62">Group</td> <td class="xl65" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 377pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="503">Combined</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">0661313</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613131</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Stained glass</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613131 - Stained glass</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">0661313</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613132</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Engraved glass</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613132 - Engraved glass</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">0661313</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613133</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Other decorative finishes for glass</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613133 - Other decorative finishes for glass</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">0661313</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613134</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Window leading materials</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613134 - Window leading materials</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1212311</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212311</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Complete culvert systems</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21231</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212311 - Complete culvert systems</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1212312</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L212312</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Culvert components</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21231</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L212312 - Culvert components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1212331</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212331</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Filter drains and channels</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21233</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212331 - Filter drains and channels</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216111</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216111</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete canal locks</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21611</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216111 - Complete canal locks</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216112</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216112</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Canal lock components</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21611</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216112 - Canal lock components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216131</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216131</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete dams</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21613</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216131 - Complete dams</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216132</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216132</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Dam components</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21613</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216132 - Dam components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216141</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216141</td> <td class="xl71" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete spillways</td> <td class="xl66" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21614</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216141 - Complete spillways</td> </tr> </tbody></table>
Column description:
Order = added to get another validation drop down list to work (orders by length of code first, then number)
Element = the code
Description = code's description
Group = parent code the current code belongs to
Combined = used with offset() to display correctly in drop down lists


Should I alter the tables or alter the formula or something else entirely?
 
Sort by date Sort by votes

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
I searched the net and found an array formula that removes the blanks from an adjacent column.
http://www.cpearson.com/excel/noblanks.htm

I added some columns to the table and changed my source formula as below.
This seems to work!


New defined names (Table columns):
TblLb = Blanks removed (array formula {=IF(ROW()-ROW(TblLb)+1>ROWS(TblLs)-COUNTBLANK(TblLs),"",INDIRECT(ADDRESS(SMALL((IF(TblLs<>"",ROW(TblLs),ROW()+ROWS(TblLs))),ROW()-ROW(TblLb)+1),COLUMN(TblLs),4)))}

TblLs = if description contains search word then display result from combined column
=IF(ISERR(SEARCH(Elem0S,TblL[[#This Row],[Description]])),"",TblL[[#This Row],[Combined]])

TblLi = Display "1" if TblLb adjacent row is not blank
=IF(TblL[[#This Row],[Blanks removed]]<>"","1","")

Elem0S = Search text


My Validation list source formula:
OFFSET(TblLi,MATCH("1",TblLi,0)-1,1,COUNTIF(TblLi,"1"),1)
the lists the results as desired

My table now looks like this:

<table style="border-collapse: collapse; width: 964pt;" border="0" cellpadding="0" cellspacing="0" width="1285"><col style="width: 56pt;" width="74"> <col style="width: 221pt;" width="295"> <col style="width: 47pt;" width="63"> <col style="width: 149pt;" width="199"> <col style="width: 56pt;" width="75"> <col style="width: 173pt;" width="230"> <col style="width: 47pt;" width="62"> <col style="width: 215pt;" width="287"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="border-style: solid; border-color: rgb(79, 129, 189); border-width: 0.5pt 0.5pt 1pt; height: 15pt; width: 56pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" height="20" width="74">Order
(TblLo)
</td> <td class="xl66" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 221pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="295">Search
(TblLs)
</td> <td class="xl65" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 47pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="63">Include (TblLi)</td> <td class="xl66" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 149pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="199">Blanks removed
(TblLb)
</td> <td class="xl68" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 56pt; font-size: 11pt; color: blue; font-weight: 700; text-decoration: none; font-family: Calibri;" width="75">Element
(TblLe)
</td> <td class="xl69" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 173pt; font-size: 11pt; color: blue; font-weight: 700; text-decoration: none; font-family: Calibri;" width="230">Description
(TblLd)
</td> <td class="xl67" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 47pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="62">Group
(TblLg)
</td> <td class="xl63" style="border-style: solid solid solid none; border-color: rgb(79, 129, 189) rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: 0.5pt 0.5pt 1pt medium; width: 215pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" width="287">Combined
(TblLc)
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">0661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613131 - Stained glass</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613131 - Stained glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613131</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Stained glass</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613131 - Stained glass</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">0661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613132 - Engraved glass</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613132 - Engraved glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613132</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Engraved glass</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613132 - Engraved glass</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">0661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613133 - Other decorative finishes for glass</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613133 - Other decorative finishes for glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613133</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Other decorative finishes for glass</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613133 - Other decorative finishes for glass</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">0661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661301 - Flat glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613134</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Window leading materials</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661313</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6613134 - Window leading materials</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1212311</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661302 - Toughened glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212311</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Complete culvert systems</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21231</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212311 - Complete culvert systems</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1212312</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661303 - Laminated glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L212312</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Culvert components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21231</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L212312 - Culvert components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1212331</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661304 - Wired/corrugated wired glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212331</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Filter drains and channels</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21233</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L212331 - Filter drains and channels</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216111</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661305 - Obscured/translucent/opaque glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216111</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete canal locks</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21611</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216111 - Complete canal locks</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216112</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661306 - Mirror glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216112</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Canal lock components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21611</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216112 - Canal lock components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216131</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661307 - Reflective/diffuse reflection glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216131</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete dams</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21613</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216131 - Complete dams</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216132</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661308 - Coloured/tinted glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216132</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Dam components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21613</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216132 - Dam components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216141</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661309 - Decorative glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216141</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete spillways</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21614</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216141 - Complete spillways</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216142</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661310 - Solar control glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216142</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Spillway components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21614</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216142 - Spillway components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216161</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L661311 - Safety glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216161</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete barrages</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21616</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216161 - Complete barrages</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216162</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L661313 - Architectural glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216162</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Barrage components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21616</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216162 - Barrage components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216211</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L22106 - Greenhouses, glasshouses</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216211</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete floating dock systems</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21621</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216211 - Complete floating dock systems</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216212</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L76255 - Alarm glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216212</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Floating dock components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21621</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216212 - Floating dock components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216221</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L3225 - Glass blocks</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216221</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete loading ramp systems</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21622</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216221 - Complete loading ramp systems</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216222</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L3343 - Glassfibre tendons</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216222</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Loading ramp components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21622</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216222 - Loading ramp components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216231</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L4186 - Films applied to glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216231</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete pontoon systems</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21623</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216231 - Complete pontoon systems</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216232</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6122 - Glass aggregate, expanded</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216232</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Pontoon components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21623</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216232 - Pontoon components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216241</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L6332 - Glass</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216241</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Complete jetty systems</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21624</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216241 - Complete jetty systems</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216242</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L6613 - Glass sheets</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216242</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Jetty components</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21624</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216242 - Jetty components</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1216251</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L216251</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Tetrapods</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21625</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L216251 - Tetrapods</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1216259</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216259</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Other breakwater products</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21625</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L216259 - Other breakwater products</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1217111</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L217111</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Desalination plant products</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21711</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L217111 - Desalination plant products</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1217112</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L217112</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Tanks, filters, etc. for treatment</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21711</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L217112 - Tanks, filters, etc. for treatment</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1217113</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L217113</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Chlorination products</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21711</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L217113 - Chlorination products</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1217114</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L217114</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Deionisation/distillation products</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21711</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L217114 - Deionisation/distillation products</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;" height="20">1217121</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">L217121</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri;">Water mains</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L21712</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri;">L217121 - Water mains</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none solid solid; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189); border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">1217122</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L217122</td> <td class="xl70" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: blue; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Booster pumps</td> <td class="xl64" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L21712</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(79, 129, 189) rgb(79, 129, 189) -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L217122 - Booster pumps</td> </tr> </tbody></table>

Any thoughts on tidying this up?
I'd like to get rid of the column "Include (TblLi)"
 
Upvote 0
Not worried about the look of the table, its just for the sake of simplicity.

Since adding that array formula, my spreadsheet is getting a bit slow.
I thought removing a step would help a bit.

The validation list source formula:
OFFSET(TblLi,MATCH("1",TblLi,0)-1,1,COUNTIF(TblLi,"1"),1)

I hoped to change it to something along the lines of:
List rows in TblLb that are not blank, upto when they start being blank
....I'm sure I have to use something like SUMPRODUCT or COUNTIF differently.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
537
smozgur
smozgur
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA code clean up
Replies
9
Views
482
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
633
Micron
M
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

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