ronicaroman
New Member
- Joined
- Dec 2, 2011
- Messages
- 25
Please help identify the write formula to return values in column D. The idea is that if people share the same number in column B and the same color in column C, column D should be "true". If they have the same number in column B but different colors in column C, the value in column D should be false.
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
A | B | C | D |
Tim | 654 | Red | TRUE |
Becky | 654 | Red | TRUE |
Susan | 23 | Green | TRUE |
Nancy | 23 | Green | TRUE |
Ruben | 23 | Green | TRUE |
David | 7899 | Blue | FALSE |
Mike | 7899 | Purple | FALSE |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>