andersonbda
New Member
- Joined
- Dec 4, 2011
- Messages
- 14
I am looking to populate column C with a "Yes" or "No" value depending on if it meets the criteria in column B for contracts in column A. Each contract can have unlimited values in column B (actually 100 max), but each value is entered onto a new line and the contract is duplicated. Column B has a range from 1-10.
Here is the criteria for column C. Each contract in column A has to have values in column B = 8 or 7 or (1 and 9) or (1 and 10) or (4 and 9) or (4 and 10).</SPAN></SPAN>
Here is example data. Please help me with the formula for column C. Thank you!!!</SPAN></SPAN>
[TABLE="width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]Logic
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]TTT
[/TD]
[TD]8
[/TD]
[TD]YES
[/TD]
[TD]TTT = 8</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]DDD
[/TD]
[TD]1
[/TD]
[TD]YES
[/TD]
[TD]DDD = 1 and 10</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]DDD
[/TD]
[TD]9
[/TD]
[TD]YES
[/TD]
[TD]DDD = 1 and 10</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]DDD
[/TD]
[TD]10
[/TD]
[TD]YES
[/TD]
[TD]DDD = 1 and 10</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]EEE
[/TD]
[TD]4
[/TD]
[TD]NO
[/TD]
[TD]EEE does not meet any of the criteria</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]EEE
[/TD]
[TD]2
[/TD]
[TD]NO
[/TD]
[TD]EEE does not meet any of the criteria</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Here is the criteria for column C. Each contract in column A has to have values in column B = 8 or 7 or (1 and 9) or (1 and 10) or (4 and 9) or (4 and 10).</SPAN></SPAN>
Here is example data. Please help me with the formula for column C. Thank you!!!</SPAN></SPAN>
[TABLE="width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]Logic
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]TTT
[/TD]
[TD]8
[/TD]
[TD]YES
[/TD]
[TD]TTT = 8</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]DDD
[/TD]
[TD]1
[/TD]
[TD]YES
[/TD]
[TD]DDD = 1 and 10</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]DDD
[/TD]
[TD]9
[/TD]
[TD]YES
[/TD]
[TD]DDD = 1 and 10</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]DDD
[/TD]
[TD]10
[/TD]
[TD]YES
[/TD]
[TD]DDD = 1 and 10</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]EEE
[/TD]
[TD]4
[/TD]
[TD]NO
[/TD]
[TD]EEE does not meet any of the criteria</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]EEE
[/TD]
[TD]2
[/TD]
[TD]NO
[/TD]
[TD]EEE does not meet any of the criteria</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]