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>
<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>
</tbody>
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>
Recipe Title | One_click | DT1 | DT2 | DT3 | DT4 | DT5 | DT6 | DT7 | HD1 | AC1 | AC2 | CC1 | CC2 | |
Subtotals --------> | 7 | 5 | 12 | 18 | 6 | 5 | 10 | 0 | 22 | 5 | 5 | 3 | 3 | |
Column to Filter On | ||||||||||||||
Max Number | ||||||||||||||
Header Name | ||||||||||||||
recipe_uid | Questions → Recipe Title ↓ | Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 | Header 9 | Header 10 | Header 11 | Header 12 | Header 13 |
R1 | Letter 1 | x | x | x | x | x | x | |||||||
R2 | Letter 2 | x | x | x | x | |||||||||
R3 | Letter 3 | x | x | x | x | |||||||||
R4 | Letter 4 | x | x | x | x | |||||||||
R48 | Letter 5 | x | x | x | x | x | ||||||||
R5 | Letter 6 | x | x | x | x | x | ||||||||
R6 | Letter 7 | x | x | x | x | x | x | |||||||
R7 | Letter 8 | x | x | x | x | |||||||||
R8 | Letter 9 | x | x | |||||||||||
R9 | Letter 10 | x | x | x | x | x | ||||||||
R10 | Letter 11 | x | x | x | x | |||||||||
R11 | Letter 12 | x | x | x | x | |||||||||
R12 | Letter 13 | x | x | x | x | |||||||||
R13 | Letter 14 | x | x | x | x | x | ||||||||
R14 | Letter 15 | x | x | x | x | x | ||||||||
R15 | Letter 16 | x | x | |||||||||||
R16 | Letter 17 | x | x | x | x | |||||||||
R17 | Letter 18 | x | x | x | x | |||||||||
R18 | Letter 19 | x | x | x | x | |||||||||
R19 | Letter 20 | x | x | x | | |||||||||
R20 | Letter 21 | x | x | x | ||||||||||
R21 | Letter 22 | x | x | x | x | |||||||||
R22 | Letter 23 | x | x | x | ||||||||||
R23 | Letter 24 | x | x | x | ||||||||||
R24 | Letter 25 | x | x | |||||||||||
R25 | Letter 26 | x | x |
<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>
</tbody>
I hope this post make up there. Cheers
TW