I have a sheet where I need to match a pass or fail to line up with a specific tool ID.
Column D ( has tool list in it ), Column O ( has results ) I need to match up passes and fails from column O to the specific tools listed in Column D
Chart Summary
<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 69px"> <col style="WIDTH: 73px"> <col style="WIDTH: 63px"> <col style="WIDTH: 46px"> <col style="WIDTH: 74px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td> <td>J</td> <td>K</td> <td>L</td> <td>M</td> <td>N</td> <td>O</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Group</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Mean</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Yield</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">N</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">StdDev</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Min</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile05</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile25</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Median</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile75</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile95</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Max</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td></tr></tbody></table>
Excel tables to the web >> Excel Jeanie HTML 4
Column D ( has tool list in it ), Column O ( has results ) I need to match up passes and fails from column O to the specific tools listed in Column D
Chart Summary
<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 69px"> <col style="WIDTH: 73px"> <col style="WIDTH: 63px"> <col style="WIDTH: 46px"> <col style="WIDTH: 74px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"> <col style="WIDTH: 73px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td> <td>J</td> <td>K</td> <td>L</td> <td>M</td> <td>N</td> <td>O</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Group</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Mean</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Yield</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">N</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">StdDev</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Min</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile05</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile25</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Median</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile75</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">PTile95</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">Max</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.545565963</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.02989709</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.053500064</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JI01</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0.050352998</td></tr></tbody></table>
Excel tables to the web >> Excel Jeanie HTML 4