Creating a macro

[Bethl1995]

Im looking to create a macro which will put true or False in column C if column A has the same value but column d has blanks.

example Column A - 001 should show as false as there is 3 lines with no date in column D, where as 097 should show as True

[#2]

@Bethl1995 In C2 enter:

=COUNTIF([Job Card Number],[@[Job Card Number]])=COUNTIFS([Job Card Number],[@[Job Card Number]],[Date Received],"<>")

That should do it. No VBA needed.

[#3]

@Riny_van_Eekelen 

thank you this has still marked all as True expect JC 88

[#4]

@Bethl1995 Can you show a screenshot including the formula bar? Or even better, share the file. Attach it if you can or share it via Onedrive or similar.

Edit: Are you sure that D4, 5, and 6 are empty?