Find duplicates and highlight the bigger value

[Rostuse]

Dears,

Hello, I would really appreciate it if you can help me out with this one.

As you can see in the sample, I have a table Phase for my articles to be made in separate machines, and how many peaces done by the same one.

In some cases, the same piece can be done in two separate machines, but in one machine you can make more pieces.

So I would like to highlight the highest number done.

Thank you.

Cycle Time.xlsx
	A	B	C	D
1	Phase	ArticleID	Machine	Peaces done
2	P1	ID1	M1	150
3	P1	ID1	M2	10
4	P2	ID1	M3	200
5	P2	ID2	M3	200
6	P3	ID2	M4	150
7	P3	ID2	M4	50
8	P4	ID1	M5	80
9	P5	ID1	M6	70
Sheet1

 

[kevin9999]

Sorry, just noticed you're on 2016, so post #10 won't work for you.

 

[kevin9999]

Try this instead:

count max.xlsx
	A	B	C	D	E	F
3	ArticlePhase	ArticleName	MachineName	WorkingTime	Quantity	RESULT
4	20001	ASA24310025	010 QUICK E 1000	19731	190	0
5	20001	ASA24310025	078 STUDER S33	5899	35	0
6	20001	ASA41470167	010 QUICK E 1000	14205	100	100
7	20001	ASA41470229	078 STUDER S33	6054	40	40
8	20001	ASA41470556	010 QUICK E 1000	2439	17	0
9	20001	ASA41470556	078 STUDER S33	976	6	0
10	20001	ASA51600481	078 STUDER S33	2858	19	19
11	20001	ASA60670078	078 STUDER S33	1708	20	20
12	20001	ASAC03500131	078 STUDER S33	3007	10	10
13	20001	ASAC0350044	078 STUDER S33	16857	120	120
14	20001	ASAC0350076	078 STUDER S33	5060	40	40
15	20001	ASAC0350077	078 STUDER S33	7714	41	41
16	20001	ASAC0350080	010 QUICK E 1000	11817	91	0
17	20001	ASAC0350080	078 STUDER S33	197886	1557	0
18	20001	ASAC0350081	010 QUICK E 1000	9869	68	0
19	20001	ASAC0350081	078 STUDER S33	55103	330	0
20	20001	ASAC0410001	078 STUDER S33	35882	1127	1127
21	20001	ASAC55K0002	010 QUICK E 1000	9663	54	0
22	20001	ASAC55K0002	078 STUDER S33	96993	812	812
23	20001	ASAC55K0013	010 QUICK E 1000	13519	41	0
24	20001	ASAC55K0013	078 STUDER S33	34949	208	208
25	20001	ASAC55K0014	078 STUDER S33	10093	37	37
26	20001	ASAC55P0002	010 QUICK E 1000	76853	1673	1673
27	20001	ASAC55P0002	078 STUDER S33	127479	1306	0
28	20001	ASANC350362	010 QUICK E 1000	10900	57	57
29	20002	ASA24310022	078 STUDER S33	3893	39	39
30	20002	ASA31400140	078 STUDER S33	2322	11	11
31	20002	ASA31400310	078 STUDER S33	1839	9	9
32	20002	ASA31400400	078 STUDER S33	19625	155	155
33	20002	ASA34310050	078 STUDER S33	0	20	20
34	20002	ASA24310025	010 QUICK E 1000	9812	198	0
35	20002	ASA24310025	078 STUDER S33	25236	204	204
36	20002	ASA41470193	078 STUDER S33	6213	24	24
37	20002	ASA41470200	078 STUDER S33	250	2	2
38	20002	ASA41470205	078 STUDER S33	14880	129	129
39	20002	ASA41470556	078 STUDER S33	10424	62	62
40	20002	ASAC0350047	078 STUDER S33	7205	40	40
41	20002	ASAC0350080	010 QUICK E 1000	21078	198	0
42	20002	ASAC0350080	078 STUDER S33	555901	3406	3406
43	20002	ASAC0350081	078 STUDER S33	54572	388	388
44	20002	ASAC0410001	078 STUDER S33	138649	1092	0
Sheet1 (2)

Cell Formulas
Range	Formula
F4:F44	F4	=IF(AGGREGATE(14,4,($B$4:$B$44=B4)*$E$4:$E$44,1)=E4,E4,0)