Combination of column headings

klausee

New Member
Joined
Jul 31, 2008
Messages
25
Hello -
I have searched the entire forum and am unable to find a specific resolve to this situation.

I have six columns - A, B, C, D, E, and F; each with a number 1 in a particular cell. what i need to do is identify which cells in that row have a one and return the column heading for that cell. If there are multiple combinations such as column A, E, and F have a "1", then return A,E,F in a separate cell...

<TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=384 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>A</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>B</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>D</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>E</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>F</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"> </TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"> </TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"> </TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"> </TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> </TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

Any suggestions?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
<TABLE style="WIDTH: 672pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=896 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=14 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl38 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17> </TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>A</TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64 x:str="B ">B </TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64 x:str="C ">C </TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64 x:str="D ">D </TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64 x:str="E ">E </TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64 x:str="F ">F </TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>G</TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>H</TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>I</TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>J</TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>K</TD><TD class=xl39 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>L</TD><TD class=xl40 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>O</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18> </TD><TD class=xl27 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64 x:str="A ">A

</TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64 x:str="B ">B </TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64 x:str="C ">C </TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64 x:str="D ">D </TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64 x:str="E ">E </TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64 x:str="F ">F </TD><TD class=xl27 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64>A

</TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64>B</TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64>C</TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64>D</TD><TD class=xl28 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64>E</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64>F</TD><TD class=xl42 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white" width=64>Total</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>1</TD><TD class=xl30 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl24 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl24 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl24 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl24 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B3=1,+B$2,"")'>A </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C3=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(D3=1,+D$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E3=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F3=1,+F$2,"")'></TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="F " x:fmla='=IF(G3=1,+G$2,"")'>F </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H3&I3&J3&K3&L3&M3)">A F</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>2</TD><TD class=xl32 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl26 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B4=1,+B$2,"")'>A </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C4=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="C " x:fmla='=IF(D4=1,+D$2,"")'>C </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E4=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F4=1,+F$2,"")'></TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(G4=1,+G$2,"")'> </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H4&I4&J4&K4&L4&M4)">A C</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>3</TD><TD class=xl34 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl26 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl26 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(B5=1,+B$2,"")'> </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C5=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="C " x:fmla='=IF(D5=1,+D$2,"")'>C </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E5=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="E " x:fmla='=IF(F5=1,+F$2,"")'>E </TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(G5=1,+G$2,"")'> </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H5&I5&J5&K5&L5&M5)">C E</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>4</TD><TD class=xl32 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl26 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B6=1,+B$2,"")'>A </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C6=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="C " x:fmla='=IF(D6=1,+D$2,"")'>C </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E6=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F6=1,+F$2,"")'></TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(G6=1,+G$2,"")'> </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H6&I6&J6&K6&L6&M6)">A C</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>5</TD><TD class=xl32 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B7=1,+B$2,"")'>A </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C7=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(D7=1,+D$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E7=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F7=1,+F$2,"")'></TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="F " x:fmla='=IF(G7=1,+G$2,"")'>F </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H7&I7&J7&K7&L7&M7)">A F</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>6</TD><TD class=xl32 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl26 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B8=1,+B$2,"")'>A </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C8=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="C " x:fmla='=IF(D8=1,+D$2,"")'>C </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E8=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F8=1,+F$2,"")'></TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(G8=1,+G$2,"")'> </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H8&I8&J8&K8&L8&M8)">A C</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl41 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>7</TD><TD class=xl32 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl26 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl25 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: #ffffcc 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl36 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B9=1,+B$2,"")'>A </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C9=1,+C$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="C " x:fmla='=IF(D9=1,+D$2,"")'>C </TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E9=1,+E$2,"")'></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F9=1,+F$2,"")'></TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(G9=1,+G$2,"")'> </TD><TD class=xl43 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H9&I9&J9&K9&L9&M9)">A C</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl44 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" align=right height=18 x:num>8</TD><TD class=xl45 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl46 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl47 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" align=right width=64 x:num u1:num>1</TD><TD class=xl46 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl46 style="BORDER-RIGHT: #ffffcc 1pt solid; BORDER-TOP: #ffffcc; BORDER-LEFT: #ffffcc; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" width=64>

</TD><TD class=xl48 id=td_post_1861017 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl49 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:str="A " x:fmla='=IF(B10=1,+B$2,"")'>A </TD><TD class=xl50 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(C10=1,+C$2,"")'> </TD><TD class=xl50 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:str="C " x:fmla='=IF(D10=1,+D$2,"")'>C </TD><TD class=xl50 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(E10=1,+E$2,"")'> </TD><TD class=xl50 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(F10=1,+F$2,"")'> </TD><TD class=xl51 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:str="" x:fmla='=IF(G10=1,+G$2,"")'> </TD><TD class=xl52 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla="=TRIM(H10&I10&J10&K10&L10&M10)">A C</TD></TR></TBODY></TABLE>

For the second group of A-F, Cell G2 Enter formula =IF(A2=1,+A$1,"")
Copy this to the rest of the block

The total column at the end is =TRIM(G2&H2&I2&J2&K2&L2)

I cheated by putting a space in after the letters
 
Upvote 0

Forum statistics

Threads
1,214,780
Messages
6,121,522
Members
449,037
Latest member
tmmotairi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top