If then formula help

[ronicaroman]

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.

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>

 

[Eric W]

Try in D1:

=COUNTIFS($B$1:$B$7,B1,$C$1:$C$7,C1)>1

 

[ronicaroman]

Thank you so much!

 

[Eric W]

You're welcome!

Thanks for the feedback.