Max Number in Column while using filtering

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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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
 
Upvote 0

Forum statistics

Threads
1,223,712
Messages
6,174,031
Members
452,542
Latest member
Bricklin

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