Excel Duplicate Check

[cjpascoe1]

I have a list of Companies & Contacts with a column labeled 'Called this year'

I'm looking to find a formula that will include All contacts at the same company if one contact at the company has been called

Example, Geico, Called Tanya, but not Francene, in this case I would put another column with a yes on both contacts

Company	Contact	Called this Year?
Aflac	John Smith	Yes
Geico	Francene Frederick
Geico	Tanya Waylon	Yes
Liberty Mutual	Royle Jayden
Liberty Mutual	Heath Diana
Nationwide	Lucy Arlie	Yes
Nationwide	Christobel Emily	Yes
Progressive	Stew Aubrie
Progressive	Lambert Madisyn	Yes
State Farm	Michelle Pierce
State Farm	Kizzy Edwyna	Yes
State Farm	Caden Holly
USAA	Todd Shirlee	Yes

 

[etaf]

if any company has a YES, than mark as yes for all the company entries

=IF(COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,"yes")>0,"yes","no")

unless i misunderstood

Book3
	A	B	C	D
1	Company	Contact	Called this Year?	Company Called
2	Aflac	John Smith	Yes	yes
3	Geico	Francene Frederick		yes
4	Geico	Tanya Waylon	Yes	yes
5	Liberty Mutual	Royle Jayden		no
6	Liberty Mutual	Heath Diana		no
7	Nationwide	Lucy Arlie	Yes	yes
8	Nationwide	Christobel Emily	Yes	yes
9	Progressive	Stew Aubrie		yes
10	Progressive	Lambert Madisyn	Yes	yes
11	State Farm	Michelle Pierce		yes
12	State Farm	Kizzy Edwyna	Yes	yes
13	State Farm	Caden Holly		yes
14	USAA	Todd Shirlee	Yes	yes
Sheet1

Cell Formulas
Range	Formula
D2:D14	D2	=IF(COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,"yes")>0,"yes","no")