Please help! about Dynamic Conditioning

pistonss

New Member
Joined
Nov 23, 2017
Messages
4
Hello All,

I have a question. If I want to create one last column (in this case it's called "Criteria Met?") in which it will show "Yes" if the conditions on its left are shown "Yes" as well. However, I want to be able to choose which of the 4 conditions I want the last column to take into consideration. And the way I'm gonna do that is to put number "1" on top of each conditions' columns; meaning if a condition doesn't have "1" on top of its column, I don't want my last column to even take it as one of the criteria in order to show "Yes". Is it possible to a kind of dynamic conditioning like this? Thank you :)



111
ItemCondition 1Condition 2Condition 3Condition 4Criteria met?
AYesYesYesYes
BYes
CYesYes
DYesYesYesYes
EYesYesYes
F
GYes
HYes
IYesYesYesYes

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,571
Office Version
  1. 365
Platform
  1. Windows
Is this, copied down, what you mean?

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: center;;"></td><td style="text-align: center;;">1</td><td style="text-align: center;;"></td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: center;;">Item</td><td style="text-align: center;;">Condition 1</td><td style="text-align: center;;">Condition 2</td><td style="text-align: center;;">Condition 3</td><td style="text-align: center;;">Condition 4</td><td style="text-align: center;;">Criteria met?</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: center;;">A</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: center;;">B</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">Yes</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: center;;">C</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: center;;">D</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: center;;">E</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;"></td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: center;;">F</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: center;;">G</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">Yes</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: center;;">H</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">Yes</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="text-align: center;;">I</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td><td style="text-align: center;;">Yes</td></tr></tbody></table><p style="width:11.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Conditions met</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F3</th><td style="text-align:left">=IF(<font color="Blue">COUNTIFS(<font color="Red">B$1:E$1,1,B3:E3,"Yes"</font>)=COUNTIF(<font color="Red">B$1:E$1,1</font>),"Yes",""</font>)</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,130,182
Messages
5,640,668
Members
417,160
Latest member
Timon82

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
Top