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
Schedule	Item	Comment
Yes	Check
Yes
Yes	Check
Yes
No
No
Yes	Check

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]123456[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]876543[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]123456[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]345678[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]123456[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]345678[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]123456[/TD]

</tbody>

Sheet7​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=IF(AND(A2="yes",COUNTIFS(A:A,"yes",B:B,B2)>1),"Check","")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[manojs1234]

Welcome to the Board.

Thank you very much. It worked !!

 

[Eric W]

Happy to help!