Requesting Formula Help

[manojs1234]

Hello,

I have a table with 2 columns (Schedule, Item) of data and I would like to create a formula under the 3rd column using under the criteria below.

Criteria : If Column A (Schedule) shows "Yes" and if there are multiple occurrences of the same value on Column B (Item) that satisfies the condition "Yes" (in this case value 123456), I would like to populate a comment "Check" under the 3rd Column.

I tired using COUNTIF to find the duplicates, but my knowledge does not go far enough to add condition to look for "Yes" under Column A. Can anyone help?

Thank you

Schedule Item Comment
Yes 123456 Check
Yes 876543
Yes 123456 Check
Yes 345678
No 123456
No 345678
Yes 123456 Check

 

[Eric W]

Welcome to the Board.

How about?

Excel 2012

	A	B	C
1	Schedule	Item	Comment
2	Yes	123456	Check
3	Yes	876543
4	Yes	123456	Check
5	Yes	345678
6	No	123456
7	No	345678
8	Yes	123456	Check

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet7​

Worksheet Formulas Cell Formula C2 =IF(AND(A2="yes",COUNTIFS(A:A,"yes",B:B,B2)>1),"Check","") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[manojs1234]

Welcome to the Board.

Thank you very much. It worked !!

 

[Eric W]

Happy to help!