walkertatl9803
New Member
- Joined
- Aug 8, 2017
- Messages
- 2
Hi everyone..not sure if my last post got posted. I have sheet that has list of letters and list of headers. In each column there are a number of Xs associated with a given list of letters. I need to create a subtotal at the top of each header column, then identify the MAX number of Xs in a given column. Once I have the max number, I want that max number populated in a cell along with a name of the header displayed in a separate cell. Each time I filter on the MAX number the sheet should dynamically recalculate the subtotal, max and name of the header.
Here is the data:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { text-align: center; }.xl68 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }.xl69 { text-align: center; border: 0.5pt solid windowtext; }.xl70 { text-align: center; border: 0.5pt solid windowtext; white-space: normal; }</style> [TABLE="width: 1168"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:4010;width:94pt" width="125"> <col style="mso-width-source:userset;mso-width-alt:9770;width:229pt" width="305"> <col style="width:65pt" span="13" width="87"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 125"] [/TD]
[TD="class: xl69, width: 305"]Recipe Title[/TD]
[TD="class: xl69, width: 87"]One_click[/TD]
[TD="class: xl69, width: 87"]DT1[/TD]
[TD="class: xl69, width: 87"]DT2[/TD]
[TD="class: xl69, width: 87"]DT3[/TD]
[TD="class: xl69, width: 87"]DT4[/TD]
[TD="class: xl69, width: 87"]DT5[/TD]
[TD="class: xl69, width: 87"]DT6[/TD]
[TD="class: xl69, width: 87"]DT7[/TD]
[TD="class: xl69, width: 87"]HD1[/TD]
[TD="class: xl69, width: 87"]AC1[/TD]
[TD="class: xl69, width: 87"]AC2[/TD]
[TD="class: xl69, width: 87"]CC1[/TD]
[TD="class: xl69, width: 87"]CC2[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]Subtotals -------->[/TD]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]12[/TD]
[TD="class: xl69"]18[/TD]
[TD="class: xl69"]6[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]0[/TD]
[TD="class: xl69"]22[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]3[/TD]
[/TR]
[TR]
[TD="class: xl68"]Column to Filter On[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl68"]Max Number[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl68"]Header Name[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]recipe_uid[/TD]
[TD="class: xl69"] Questions →
Recipe Title ↓
[/TD]
[TD="class: xl70, width: 87"]Header 1[/TD]
[TD="class: xl70, width: 87"]Header 2[/TD]
[TD="class: xl70, width: 87"]Header 3[/TD]
[TD="class: xl70, width: 87"]Header 4[/TD]
[TD="class: xl70, width: 87"]Header 5[/TD]
[TD="class: xl70, width: 87"]Header 6[/TD]
[TD="class: xl70, width: 87"]Header 7[/TD]
[TD="class: xl70, width: 87"]Header 8[/TD]
[TD="class: xl70, width: 87"]Header 9[/TD]
[TD="class: xl70, width: 87"]Header 10[/TD]
[TD="class: xl70, width: 87"]Header 11[/TD]
[TD="class: xl70, width: 87"]Header 12[/TD]
[TD="class: xl70, width: 87"]Header 13[/TD]
[/TR]
[TR]
[TD="class: xl69"]R1[/TD]
[TD="class: xl69"]Letter 1[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[/TR]
[TR]
[TD="class: xl69"]R2[/TD]
[TD="class: xl69"]Letter 2[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R3[/TD]
[TD="class: xl69"]Letter 3[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R4[/TD]
[TD="class: xl69"]Letter 4[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R48[/TD]
[TD="class: xl69"]Letter 5[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R5[/TD]
[TD="class: xl69"]Letter 6[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[/TR]
[TR]
[TD="class: xl69"]R6[/TD]
[TD="class: xl69"]Letter 7[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[/TR]
[TR]
[TD="class: xl69"]R7[/TD]
[TD="class: xl69"]Letter 8[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R8[/TD]
[TD="class: xl69"]Letter 9[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R9[/TD]
[TD="class: xl69"]Letter 10[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R10[/TD]
[TD="class: xl69"]Letter 11[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R11[/TD]
[TD="class: xl69"]Letter 12[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R12[/TD]
[TD="class: xl69"]Letter 13[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R13[/TD]
[TD="class: xl69"]Letter 14[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R14[/TD]
[TD="class: xl69"]Letter 15[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R15[/TD]
[TD="class: xl69"]Letter 16[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R16[/TD]
[TD="class: xl69"]Letter 17[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R17[/TD]
[TD="class: xl69"]Letter 18[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R18[/TD]
[TD="class: xl69"]Letter 19[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R19[/TD]
[TD="class: xl69"]Letter 20[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]
[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R20[/TD]
[TD="class: xl69"]Letter 21[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R21[/TD]
[TD="class: xl69"]Letter 22[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R22[/TD]
[TD="class: xl69"]Letter 23[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R23[/TD]
[TD="class: xl69"]Letter 24[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R24[/TD]
[TD="class: xl69"]Letter 25[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R25[/TD]
[TD="class: xl69"]Letter 26[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
</tbody>[/TABLE]
I hope this post make up there. Cheers
TW
Here is the data:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { text-align: center; }.xl68 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }.xl69 { text-align: center; border: 0.5pt solid windowtext; }.xl70 { text-align: center; border: 0.5pt solid windowtext; white-space: normal; }</style> [TABLE="width: 1168"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:4010;width:94pt" width="125"> <col style="mso-width-source:userset;mso-width-alt:9770;width:229pt" width="305"> <col style="width:65pt" span="13" width="87"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 125"] [/TD]
[TD="class: xl69, width: 305"]Recipe Title[/TD]
[TD="class: xl69, width: 87"]One_click[/TD]
[TD="class: xl69, width: 87"]DT1[/TD]
[TD="class: xl69, width: 87"]DT2[/TD]
[TD="class: xl69, width: 87"]DT3[/TD]
[TD="class: xl69, width: 87"]DT4[/TD]
[TD="class: xl69, width: 87"]DT5[/TD]
[TD="class: xl69, width: 87"]DT6[/TD]
[TD="class: xl69, width: 87"]DT7[/TD]
[TD="class: xl69, width: 87"]HD1[/TD]
[TD="class: xl69, width: 87"]AC1[/TD]
[TD="class: xl69, width: 87"]AC2[/TD]
[TD="class: xl69, width: 87"]CC1[/TD]
[TD="class: xl69, width: 87"]CC2[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]Subtotals -------->[/TD]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]12[/TD]
[TD="class: xl69"]18[/TD]
[TD="class: xl69"]6[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]0[/TD]
[TD="class: xl69"]22[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]3[/TD]
[/TR]
[TR]
[TD="class: xl68"]Column to Filter On[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl68"]Max Number[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl68"]Header Name[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]recipe_uid[/TD]
[TD="class: xl69"] Questions →
Recipe Title ↓
[/TD]
[TD="class: xl70, width: 87"]Header 1[/TD]
[TD="class: xl70, width: 87"]Header 2[/TD]
[TD="class: xl70, width: 87"]Header 3[/TD]
[TD="class: xl70, width: 87"]Header 4[/TD]
[TD="class: xl70, width: 87"]Header 5[/TD]
[TD="class: xl70, width: 87"]Header 6[/TD]
[TD="class: xl70, width: 87"]Header 7[/TD]
[TD="class: xl70, width: 87"]Header 8[/TD]
[TD="class: xl70, width: 87"]Header 9[/TD]
[TD="class: xl70, width: 87"]Header 10[/TD]
[TD="class: xl70, width: 87"]Header 11[/TD]
[TD="class: xl70, width: 87"]Header 12[/TD]
[TD="class: xl70, width: 87"]Header 13[/TD]
[/TR]
[TR]
[TD="class: xl69"]R1[/TD]
[TD="class: xl69"]Letter 1[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[/TR]
[TR]
[TD="class: xl69"]R2[/TD]
[TD="class: xl69"]Letter 2[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R3[/TD]
[TD="class: xl69"]Letter 3[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R4[/TD]
[TD="class: xl69"]Letter 4[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R48[/TD]
[TD="class: xl69"]Letter 5[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R5[/TD]
[TD="class: xl69"]Letter 6[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[/TR]
[TR]
[TD="class: xl69"]R6[/TD]
[TD="class: xl69"]Letter 7[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[/TR]
[TR]
[TD="class: xl69"]R7[/TD]
[TD="class: xl69"]Letter 8[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R8[/TD]
[TD="class: xl69"]Letter 9[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R9[/TD]
[TD="class: xl69"]Letter 10[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R10[/TD]
[TD="class: xl69"]Letter 11[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R11[/TD]
[TD="class: xl69"]Letter 12[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R12[/TD]
[TD="class: xl69"]Letter 13[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R13[/TD]
[TD="class: xl69"]Letter 14[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R14[/TD]
[TD="class: xl69"]Letter 15[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R15[/TD]
[TD="class: xl69"]Letter 16[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R16[/TD]
[TD="class: xl69"]Letter 17[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R17[/TD]
[TD="class: xl69"]Letter 18[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R18[/TD]
[TD="class: xl69"]Letter 19[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R19[/TD]
[TD="class: xl69"]Letter 20[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]
[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R20[/TD]
[TD="class: xl69"]Letter 21[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R21[/TD]
[TD="class: xl69"]Letter 22[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R22[/TD]
[TD="class: xl69"]Letter 23[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R23[/TD]
[TD="class: xl69"]Letter 24[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R24[/TD]
[TD="class: xl69"]Letter 25[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]R25[/TD]
[TD="class: xl69"]Letter 26[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]x[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[/TR]
</tbody>[/TABLE]
I hope this post make up there. Cheers
TW