How To Populate Remarks Conditionally Based On Group?

[xlmaniac]

Dear All,
I want to check whether the delivery dates of SKUs in any Purchase Order have the same date or not.
In case the delivery dates are different in any Purchase Order, the remarks should be FALSE or if the dates are same, then it should be TRUE.
I am providing a sample set with desired result across A1:D7.
Could somebody help me out with the solution pls?
[TABLE="width: 345"]
<tbody>[TR]
[TD]Purchase Order No[/TD]
[TD]SKU NO[/TD]
[TD]Delivery Date[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]17-Jan[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]b[/TD]
[TD]17-Jan[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]c[/TD]
[TD]17-Jan[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]q[/TD]
[TD]15-Jan[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]t[/TD]
[TD]16-Jan[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]u[/TD]
[TD]16-Jan[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

If I understood correctly, it should be something like this:

Excel 2013

	A	B	C	D
a	17-Jan
b	17-Jan
c	17-Jan
q	15-Jan
t	16-Jan
u	16-Jan

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] , align: center"]Purchase Order No[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] , align: center"]SKU NO[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] , align: center"]Delivery Date[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] , align: center"]Result[/TD]

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

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]TRUE[/TD]

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

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]TRUE[/TD]

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

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]TRUE[/TD]

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

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]FALSE[/TD]

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

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]FALSE[/TD]

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

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]FALSE[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A2)=COUNTIFS($A$2:$A$7,A2,$C$2:$C$7,C2)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D3[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A3)=COUNTIFS($A$2:$A$7,A3,$C$2:$C$7,C3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D4[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A4)=COUNTIFS($A$2:$A$7,A4,$C$2:$C$7,C4)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D5[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A5)=COUNTIFS($A$2:$A$7,A5,$C$2:$C$7,C5)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D6[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A6)=COUNTIFS($A$2:$A$7,A6,$C$2:$C$7,C6)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D7[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A7)=COUNTIFS($A$2:$A$7,A7,$C$2:$C$7,C7)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[xlmaniac]

If I understood correctly, it should be something like this:

Excel 2013

	A	B	C	D
a	17-Jan
b	17-Jan
c	17-Jan
q	15-Jan
t	16-Jan
u	16-Jan

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Purchase Order No[/TD]
[TD="align: center"]SKU NO[/TD]
[TD="align: center"]Delivery Date[/TD]
[TD="align: center"]Result[/TD]

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

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

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

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

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

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

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

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

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

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

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

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

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A2)=COUNTIFS($A$2:$A$7,A2,$C$2:$C$7,C2)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D3[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A3)=COUNTIFS($A$2:$A$7,A3,$C$2:$C$7,C3)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D4[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A4)=COUNTIFS($A$2:$A$7,A4,$C$2:$C$7,C4)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D5[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A5)=COUNTIFS($A$2:$A$7,A5,$C$2:$C$7,C5)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D6[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A6)=COUNTIFS($A$2:$A$7,A6,$C$2:$C$7,C6)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D7[/TH]
[TD="align: left"]=COUNTIF($A$2:$A$7,A7)=COUNTIFS($A$2:$A$7,A7,$C$2:$C$7,C7)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Dear VBA Geek,
Thanks for the amazing solution.
It is yielding the desired result as desired.
Really appreciate your support.
Regards
Xlmaniac