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>
<TBODY>
</TBODY>
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>
| a | b | c | Logic | |
| 1 | TTT | 8 | YES | TTT = 8</SPAN></SPAN> |
| 2 | DDD | 1 | YES | DDD = 1 and 10</SPAN></SPAN> |
| 3 | DDD | 9 | YES | DDD = 1 and 10</SPAN></SPAN> |
| 4 | DDD | 10 | YES | DDD = 1 and 10</SPAN></SPAN> |
| 5 | EEE | 4 | NO | EEE does not meet any of the criteria</SPAN></SPAN> |
| 6 | EEE | 2 | NO | EEE does not meet any of the criteria</SPAN></SPAN> |
<TBODY>
</TBODY>
