highlight duplicates demo 1

	A	B	C	D	F
1	FirstName	LastName	Email
2	Wijdan	Najjar	WijdanWafiyyahNajjar@cuvox.de	0
3	Shu'aib	Mifsud	ShuaibAshrafMifsud@rhyta.com	0	Cell D3 Formula: =SUMIF(MATCH(C3,C$2:C2,0)+1,"<>#N/A")
4	Oscar	Salting	OscarSalting@armyspy.com	0
5	Nuh	Maroun	NuhMarwanMaroun@fleckens.hu	0
6	Stephanie	Walch	StephanieWalch@jourrapide.com	0
7	Phoebe	Aronson	PhoebeAronson@armyspy.com	0
8	Kimberlee	Whitehead	OscarSalting@armyspy.com	4
9	Blake	Wrixon	BlakeWrixon@einrot.com	0
10	Awad	Asfour	AwadNashatAsfour@dayrep.com	0
11	Angelina	Strachan	AngelinaStrachan@gustr.com	0
12	Ernest	Stewart	ErnestLStewart@armyspy.com	0
13	Iyas	Guirguis	IyasJaleelGuirguis@superrito.com	0
14	Audrey	Jackson	AudreyJJackson@fleckens.hu	0
15	Kimberlee	Whitehead	KimberleeRWhitehead@einrot.com	0
16	Linda	Fox	LindaGFox@cuvox.de	0
17	Jadwa	Ganim	JadwaHasnaGanim@jourrapide.com	0
18	Fiddah	Maalouf	FiddahShakirahMaalouf@superrito.com	0
19	Donna	Berry	DonnaGBerry@teleworm.us	0
20	Russell	Lane	RussellMLane@gustr.com	0
21	Audrey	Jackson	AudreyJJackson@fleckens.hu	14
22	Cody	Cross	CodyCCross@armyspy.com	0
23	Thomas	Mansfield	ThomasEMansfield@cuvox.de	0
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100