Multiple & Variable Dynamic Count

Gonzalo De La Torre · Jan 14, 2011

Ok, I came up with the need of modifing something already solved here is the case.

In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [ =IF(COUNTIF(A$2:A2,A2)=1,COUNTIF($A:$A,A2),"") ] WORKS! , The issue came when i tried to compare if all the values in Column B of a specific serial are "C", if this is true i want it to display yes in column D "Yes", if there is another value when comparing each serial then display "NO".

Ok. Someone in this forum came up with a brilliant formula; nevertheless, I encountered the need of modifying it a little bit. I need to say yes when in column B it has C and other values. I tried modifying =C with and("C",or("Cx","Cf","F")) But apparently this solution does not fit.

=IF(C2="",D1,IF(COUNTIF(INDIRECT("B" & ROW() & ":B" & ROW()+C2-1),"=C")=C2,"Yes","No"))

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 8</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>4</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: windowtext; BACKGROUND-COLOR: transparent" width=64>NO</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: windowtext; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 9</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>NO</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 10</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>NO</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 11</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 2</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>F</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>NO</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Functional</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 12</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>2</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: windowtext; BACKGROUND-COLOR: transparent" width=64>YES</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: windowtext; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 13</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 3</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>YES</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 14</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>3</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: windowtext; BACKGROUND-COLOR: transparent" width=64>YES</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: windowtext; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 15</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>YES</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 16</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 4</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>YES</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

Another thing I need is to place in a table the result of this date.

I need to count unique values in column A that has yes in column D and has and("Stand","Cover") <--- (It could be a single description or several) in column E.

Example: For serial 1 it needs to check that the 6 values in column D are "Yes" and that both descriptions and("Stand","Cover") appear at least once to count it as 1.

The overall result for this example will be:

<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: 15pt" height=20><TD class=xl65 id=td_post_46539 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: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20></TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>QTY</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20>Result</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>2</TD></TR></TBODY></TABLE>

Since serial 1 and serial 3 meet these conditions.

I'm a little bit stuck in this last part. So far I have just come up witha formula to count unique values in Column A; nevertheless, I have failed in trying to modify it to search for the conditions I need.

This is the current formula for the results:

=SUM(IF(FREQUENCY(MATCH($A$2:$A$16,$A$2:$A$16,0),MATCH($A$2:$A$16,$A$2:$A$16,0))>0,1))

But the current result is 4.

Can anyone help me with this?

Aladin Akyurek · Jan 14, 2011

Gonzalo De La Torre said:
Yeah, sorry about that. I updated it just after I posted it. By the way I checked this formula again and it returns me #Value

=SUM(IF(FREQUENCY(IF($A$2:$A$16<>"",
IF($D$2:$D$16="Yes",IF(ISNUMBER(MATCH($E$2:$E$16,{"Stand","Cover"},0)),
MATCH("~"&$A$2:$A$16,$A$2:$A$16&"",0)))), ROW($A$2:$A$16)-ROW($A$2)+1),1))

You must confirm that FREQUENCY formula with control+shift+enter, not with just enter...

By the way...

D2, control+shift+enter, not just enter, and copy down:

Code:

=IF(ISNUMBER(MATCH("C",IF($A$2:$A$31=A2,$B$2:$B$31),0)),
    IF(ISNUMBER(MATCH({"Cx","Cf","F"},
      IF($A$2:$A$31=A2,$B$2:$B$31),0)),1,0),0)

Gonzalo De La Torre · Jan 17, 2011

Good Morning Guys! The second formula works great and serves its puprose really good. I'm still trying to find a way to make "C" a must for a "Yes" answer to be given

Aladin Akyurek · Jan 17, 2011

Gonzalo De La Torre said:
Good Morning Guys! The second formula works great and serves its puprose really good.

Thanks for the feedback.

I'm still trying to find a way to make "C" a must for a "Yes" answer to be given

A bit mystified here. Do you mean to have "Yes" instead of 1 or is it something else?

Gonzalo De La Torre · Jan 17, 2011

I was talking about this formula:

=IF(C2="",D1,IF(SUMPRODUCT(--(ISNUMBER(MATCH(OFFSET(B2,,,C2),{"C","Cx","CF","F"},0))))=C2,"Yes","No"))

It works but "C" is just optional, not necessary in order to display "Yes"

Gonzalo De La Torre said:
I was trying to say the following

Lets say we have the following case, if we have in the list Cx, Cf or F but we do not have a single C in those 6 repetitions in column B then Column D will display "NO"

(No "C" is present in the list)

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

If we have at least one "C" in column B on any of those 6 repetitions even if it has any combination of Cx,Cf,F then it will display "Yes"

(At least one "C" is present on the list and any other combinations specified in the array [Cx,Cf,F])

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

If anything else besides what we have specified in the array appears in any of the 6 repetitions in column B then it will display no.

(A character not specified in the array is present)

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>F</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>F</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cf</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Cx</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20></TD><TD class=xl64 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; BACKGROUND-COLOR: #dddddd" width=64>Column A</TD><TD class=xl65 id=td_post_46539 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd" width=64>Column C</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: #dddddd" width=64>Column D</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #dddddd; BORDER-RIGHT-COLOR: #ece9d8" width=71>Column E</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl64 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: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>6</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Stand</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 6</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent" width=71>Ring</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #dddddd" width=64 height=20>Row 7</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Serial 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>No</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; WIDTH: 53pt; BORDER-TOP-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=71>Cover</TD></TR></TBODY></TABLE>

In other words there are characters that need to be there forcely in order to say "Yes" (In this case "C"), and there should be characters specified in an array that will dictacte wich are accepted to be combined with "C", in this case ("Cx","Cf","F")

Multiple & Variable Dynamic Count

Gonzalo De La Torre

New Member

Aladin Akyurek

MrExcel MVP

Excel Facts

Gonzalo De La Torre

New Member

Aladin Akyurek

MrExcel MVP

Gonzalo De La Torre

New Member

Similar threads

Forum statistics

Share this page

Multiple & Variable Dynamic Count

Gonzalo De La Torre

New Member

Aladin Akyurek

MrExcel MVP

Excel Facts

Gonzalo De La Torre

New Member

Aladin Akyurek

MrExcel MVP

Gonzalo De La Torre

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock