counting in excel

T

tcol

New Member
Joined
Mar 8, 2011
Messages
19
HI
how can I get excel to count all each individual word or no. from the contents of table below, without having to specifically tell it what to count e.g count glassware etc?
I want a summary table of how many of each word and no. contained in the table, so I can buld a histogram.
regards
tcol

<TABLE style="WIDTH: 847pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1126 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 106pt; mso-width-source: userset; mso-width-alt: 5156" width=141><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 5302" width=145><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4169" width=114><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect pippette volume</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>High OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect std prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Standard Accuracy Check</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F1*H1*J1">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: red; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F1*H1">25</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect pippette volume</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>High OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect sample prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Internal Std</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F2*H2*J2">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: red; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F2*H2">25</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect pippette volume</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>Low OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect std prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Standard Accuracy Check</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F3*H3*J3">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: red; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F3*H3">25</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect pippette volume</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>Low OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect sample prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Internal Std</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F4*H4*J4">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: red; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F4*H4">25</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect volume volumetric flask</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>High OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect std prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>3</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Internal Std</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: lime; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F5*H5*J5">15</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F5*H5">15</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect volume volumetric flask</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>Low OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect std prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>3</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Internal Std</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: lime; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F6*H6*J6">15</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F6*H6">15</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>dirty/contaminated or damaged test tubes (and caps) or pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>High OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>cracked glassware</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>2</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Chemist initialvisual check/Initial Investigation</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>3</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F7*H7*J7">30</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F7*H7">10</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>dirty/contaminated or damaged test tubes (and caps) or pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>High OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>FK506 contaminated glassware</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Washing Procedures/Chemist visual check/Retest x 4</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>5</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F8*H8*J8">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F8*H8">5</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>hot pippettes, test tubes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>High OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect std volume transferred</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Chemist training</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>5</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F9*H9*J9">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F9*H9">5</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>hot pippettes, test tubes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>Low OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect sample volume transferred</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Chemist training</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>5</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F10*H10*J10">25</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F10*H10">5</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>wet pippettes, test tubes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>Low OOS/OOT results reported</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>diluted soln transferred</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Visual Check by washroom staff and chemist</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>3</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: lime; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F11*H11*J11">15</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F11*H11">5</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect pippette volume</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>invalid analysis</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect sample prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Internal Std</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: lime; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F12*H12*J12">5</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F12*H12">5</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>incorrect pippette volume</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>invalid analysis</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>incorrect std prep</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>5</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114>Standard Accuracy Check</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: lime; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F13*H13*J13">5</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F13*H13">5</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD class=xl24 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=57 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 82pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=109>collect glassware for sample & std including pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=102> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 106pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=141>dirty/contaminated or damaged test tubes (and caps) or pippettes</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 100pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=133>invalid analysis</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 109pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=145>poor sample chromotography</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num>3</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 86pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=114> Review by Chemist/Checker/Approver</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 47pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=62 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BACKGROUND: lime; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" align=right width=64 x:num x:fmla="=F14*H14*J14">3</TD><TD class=xl26 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" align=right width=64 x:num x:fmla="=F14*H14">3</TD></TR></TBODY></TABLE>
 
Sort by date Sort by votes
No probs. I just noticed it deleted stuff in chevrons, so this is how it should read

"You would add it to a VBA module, then use it in cells
=modulename.piece(cell ref, " ", nnn<N>)
where nnn <N>would be the n-th word."

and at the bottom

"then run an advanced filter on the list in ListSheet, specifying copy data to a new location, and unique values only, then for each item in the new list use =countif(offset($A$1,0,0,counta($A$1:$A$1000000),1), "="&[cellref]<CELL in word the with>) "
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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
622
smozgur
smozgur
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
E
  • Question Question
VBA code clean up
Replies
9
Views
582
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A

Forum statistics

Threads
1,224,586
Messages
6,179,729
Members
452,939
Latest member
WCrawford

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