counting in excel

[tcol]

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>

 

[Jonmo1]

Sounds like a job for a Pivot Table

 

[tcol]

thanks jonmo1,
just thought there might be another way, as pivot Table will only count categories?

regards
tcol

 

[MrKowz]

What exactly are you wanting to count? What is your desired result?

 

[tcol]

HI MrKowz

I want to get a count of the frequency of all individual words and no.s contained in the table attached, without having to specifically tell excel what to count.
I want a summary table of what words and no.s feature and how many times each words and no. contained in the table attached, so I can then buld a histogram.

regards
tcol

 

[Ruddles]

So if you have:-

<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 38.25pt" height=51><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: #efefef" width=64 height=51>

5​

</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64 u1:num>incorrect sample prep</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64 u1:num>

5​

</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64>Internal Std
</TD></TR></TBODY></TABLE>

You want:-

<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=128 border=0><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b8cce4" width=64 height=17>

Word​

</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #b8cce4" width=64>

Count​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #efefef" width=64 height=17>

5​

</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64 u1:num>

2​

</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #efefef" width=64 height=34>

incorrect​

</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64>

1​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #efefef" width=64 height=17>

sample​

</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64>

1​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #efefef" width=64 height=17>

prep​

</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64>

1​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #efefef" width=64 height=17>

Internal​

</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64>

1​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #efefef" width=64 height=17>

Std​

</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #efefef" width=64>

1​

</TD></TR></TBODY></TABLE>

​

Is that what you mean?

 

[tcol]

Hi Ruddles,
yes indeed you have it.......how can it be done?

regards
tcol

 

[Johnny C]

I don't think there's a simple way, i.e. without resorting to VBA.

You could build a function that separated each cell into component words, and composed a list.

Then do an advanced filter that selected unique items only into a new list, then do a frequency on each item in that list.

 

[Johnny C]

here's a piece of code that would help split each cell into the component words:

Function piece(Searchstring As String, Separator As String, IndexNum As Integer) As String
Dim i, SepCount, SepLen, StartPos, EndPos As Integer
Dim TestStr As String
SepLen = Len(Separator)
SepCount = 0
StartPos = 0
EndPos = 0
For i = 1 To Len(Searchstring) - (SepLen - 1)
    TestStr = Mid(Searchstring, i, SepLen)
    If TestStr = Separator Then
        SepCount = SepCount + 1
        If SepCount = IndexNum - 1 Then StartPos = i + 1
        If SepCount = IndexNum Then EndPos = i
    End If
Next i
If StartPos = 0 And EndPos = 0 Then
    piece = ""
    Exit Function
End If
If StartPos = 0 Then StartPos = 1
If EndPos = 0 Then EndPos = Len(Searchstring) + 1
piece = Mid(Searchstring, StartPos, EndPos - StartPos)
End Function

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

You could also call that from a loop in VBA, add a sheet called ListSheets, select the cells with data and hit a macro button, something along the lines of

nextRow = 1
for each c in selection
     for SpaceCount= 1 to 250    '(say)
          if piece(c.value," ",SpaceCount)<>"" then 
               sheets("ListSheet").cells(nextRow,1) = piece(c.value," ",spacecount)
               nextrow = nextrow+1
          else 
               SpaceCount = 251
          end if
     next SpaceCount
next c

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), "="&<cell with the word in>)

 

[tcol]

thanks Johnny C
will try & give it a lash

tcol