VBA - Comparing data and add remarks accordingly

[iris1007]

Hi,
I have a huge excel data which I need to compare the same Part # with same Ref # and add the "First" or "Repeat" in Remarks column, according to the Date.
Below is a sample:

DATE	Part #	Ref #	Remarks
15/2/2016	0145-5521-1145	37Z-138804512	First
13/3/2018	0145-5521-1145	37Z-15142396	First
18/11/2016	0145-5521-1145	37Z-16548768	First
6/12/2016	07F10-150326018	1145214	First
30/9/2014	07F10-150326018	2255551420	First
11/3/2016	07F10-150326018	2255551420	Repeat
14/12/2010	07F10-150326018	22523413G67	First
19/1/2016	07F10-150326018	22523413G67	Repeat
27/4/2016	07F10-150326018	22523413G67	Repeat
28/10/2014	07F10-150326018	22502171	First
24/6/2013	07F10-150326018	225762201D	First
9/6/2011	07F10-150326018	225F0991	First
6/9/2016	07F10-150326018	225F0991	Repeat
28/10/2011	07F10-150326018	22611AD123	First
27/7/2015	07F10-150326018	22611AD123	Repeat
27/12/2013	07F10-150326018	ABC22622	First
11/5/2015	07F10-150326018	F23201884	First
2/8/2016	07F10-150326018	F23201884	Repeat
26/1/2017	07F10-150326018	F23201884	Repeat
7/2/2012	07F10-150326018	A23267	First
3/12/2010	07F10-150326018	A23267	Repeat
13/4/2016	07F10-150326018	ZX-10-23809	First
21/8/2018	07F10-150326018	ZX-10-23809	Repeat
23/7/2014	07F10-150326018	2-A4276-00	First
25/4/2016	07F10-150326018	2-A4276-00	Repeat
30/4/2013	07F10-150326018	81A-CAA26474	First
10/12/2015	07F10-150326018	81A-CBB26680	First
14/11/2016	07F10-150326018	81A-CBB26680	Repeat
21/8/2017	07F10-150326018	81A-CDD27477	First
30/4/2013	071-50001-8102	F149120021	First
10/12/2016	071-50001-8102	F149120021	Repeat
14/11/2015	071-50001-8102	F149120021	Repeat
21/8/2017	071-50001-8102	F149120021	Repeat

<colgroup><col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4579;"> <col width="181" style="width: 136pt; mso-width-source: userset; mso-width-alt: 6428;"> <col width="122" style="width: 92pt; mso-width-source: userset; mso-width-alt: 4352;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2844;"> <tbody> </tbody>

Hope anyone of you can help me. Thank you!

 

[oldbrewer]

DATE	Part #	Ref #	Remarks			helper
15/02/2016	0145-5521-1145	37Z-138804512	First			0145-5521-114537Z-138804512
13/03/2018	0145-5521-1145	37Z-15142396	first			0145-5521-114537Z-15142396
18/11/2016	0145-5521-1145	37Z-16548768	first			0145-5521-114537Z-16548768
06/12/2016	07F10-150326018	1145214	first			07F10-1503260181145214
30/09/2014	07F10-150326018	2255551420	first			07F10-1503260182255551420
11/03/2016	07F10-150326018	2255551420	repeat			07F10-1503260182255551420
14/12/2010	07F10-150326018	22523413G67	first			07F10-15032601822523413G67
19/01/2016	07F10-150326018	22523413G67	repeat			07F10-15032601822523413G67
27/04/2016	07F10-150326018	22523413G67	repeat			07F10-15032601822523413G67
28/10/2014	07F10-150326018	22502171	first			07F10-15032601822502171
24/06/2013	07F10-150326018	225762201D	first			07F10-150326018225762201D
09/06/2011	07F10-150326018	225F0991	first			07F10-150326018225F0991
						col G
	some ref numbers are text others are numbers
	I have corrected that
	clearly the first row must be a first
	formula used to determine the "first" in D3
	=IF(SUMPRODUCT(($G$2:G2=G3)*1)=0,"first","repeat")

<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Another option
In D2 copied down
=IF(COUNTIFS($B$2:$B2,B2,$C$2:$C2,C2)=1,"First","Repeat")

 

[iris1007]

Awesome. Thank you so much for the help.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[oldbrewer]

mine is 5 characters shorter Fluff - but I did use a helper column.......