Need to return 'Yes' if all duplicate cell values have a date entered in adjacent cell

[LisaH789]

HI, I'm looking for help as everything that I've tries so far hasn't worked. I need to return

 

[LisaH789]

HI, I'm looking for help as everything that I've tries so far hasn't worked. I need to return

I need to return Yes or No in column D if all of the orders have been issued (date entered in column C) for the jobs in column A.

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

Is this what you mean?

24 11 01.xlsm
	A	B	C	D
1
2	Job1		1/01/2020	No
3	Job1			No
4	Job2		5/05/2023	Yes
5	Job3		6/05/2023	Yes
6	Job3		7/05/2023	Yes
7	Job3		8/05/2023	Yes
8	Job3		9/05/2023	Yes
9	Job3		10/05/2023	Yes
10	Job4			No
11	Job4			No
12	Job4			No
13	Job4			No
14	Job4			No
15	Job4			No
Yes No

Cell Formulas
Range	Formula
D2:D15	D2	=IF(COUNTIF(A$2:A$15,A2)=COUNTIFS(A$2:A$15,A2,C$2:C$15,"<>"),"Yes","No")

 

[LisaH789]

Hi Peter, yes that's brilliant thanks, exactly what I was looking for
I will definitely look into the XL2BB for next time as suggested.
Thanks, Lisa

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.