Max Number in Column while using filtering

[walkertatl9803]

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>

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

 

[walkertatl9803]

Hi everyone,

Here is the formula I was trying to use: =IF(E2=E3,"filter on: "&SUBSTITUTE(ADDRESS(1,MATCH(LARGE(P3:DC3,E1+1),P3:DC3,0)+14,4),"1","")&" then increment C1 by 1 if previous answer was Yes, otherwise leave C1 for No","filter on: "&SUBSTITUTE(ADDRESS(1,MATCH(E3,P3:DC3,0)+14,4),"1","")&" then increment C1 by 1 if previous answer was Yes, otherwise leave C1 for No")

Cant get it to work. As you see from my previous thread that I need help for some additional formula but ....can anyone give some advice or direction to produce the outcome I am trying to produce. Need this sheet like asap PLEASE SOMEONE if you have time, I would greatly appreciate it. Cheers TW