INDEX MATCH LARGE ... How To Avoid Duplicates?

[jamada]

HI
I have the following table that draws on data in P4:R63, however the formula appears to repeat the same answer, how do I avoid this.
IN Column "P" once a code I.E. "ANB" is used it will not need to be reported on again as this s a TOP 10 list and its ranking has already been recorded!

Thanks Graham

Excel 2010
	O	P	Q	R	S	T	U	V	W	X
66	TOP 10 - November - 2014
67
68		DH4			E75			Total Delays
69		Secondary	QTY	Percent	Secondary	QTY	Percent	Secondary	QTY	Percent
70	1	MTF	9	19.1%	MTF	39	18.8%	MTF	48	18.8%
71	2	FOR	6	12.8%	ISS	32	15.4%	ISS	35	13.7%
72	3	CNX	5	10.6%	SEB	18	8.7%	SEB	20	7.8%
73	4	ANB	3	6.4%	ANB	14	6.7%	ANB	17	6.7%
74	5	ANB	3	6.4%	LOD	13	6.3%	IFT	13	5.1%
75	6	ANB	3	6.4%	IFT	12	5.8%	IFT	13	5.1%
76	7	ANG	2	4.3%	ANG	9	4.3%	ANG	11	4.3%
77	8	ANG	2	4.3%	SES	7	3.4%	ANG	11	4.3%
78	9	ANG	2	4.3%	IFU	6	2.9%	IFO	8	3.1%
79	10	ANG	2	4.3%	ANF	5	2.4%	CNX	7	2.7%
NOVEMBER

Cell Formulas
Range	Formula
P70	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),1),R$4:R$63,0))
P71	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),2),R$4:R$63,0))
P72	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),3),R$4:R$63,0))
P73	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),4),R$4:R$63,0))
P74	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),5),R$4:R$63,0))
P75	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),6),R$4:R$63,0))
P76	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),7),R$4:R$63,0))
P77	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),8),R$4:R$63,0))
P78	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),9),R$4:R$63,0))
P79	=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),10),R$4:R$63,0))
Q70	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),1),R$4:R$63,0))
Q71	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),2),R$4:R$63,0))
Q72	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),3),R$4:R$63,0))
Q73	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),4),R$4:R$63,0))
Q74	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),5),R$4:R$63,0))
Q75	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),6),R$4:R$63,0))
Q76	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),7),R$4:R$63,0))
Q77	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),8),R$4:R$63,0))
Q78	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),9),R$4:R$63,0))
Q79	=INDEX(Q$4:Q$63,MATCH(LARGE((R$4:R$63),10),R$4:R$63,0))
R70	=LARGE(R$4:R$63,1)
R71	=LARGE(R$4:R$63,2)
R72	=LARGE(R$4:R$63,3)
R73	=LARGE(R$4:R$63,4)
R74	=LARGE(R$4:R$63,5)
R75	=LARGE(R$4:R$63,6)
R76	=LARGE(R$4:R$63,7)
R77	=LARGE(R$4:R$63,8)
R78	=LARGE(R$4:R$63,9)
R79	=LARGE(R$4:R$63,10)
S70	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),1),U$4:U$63,0))
S71	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),2),U$4:U$63,0))
S72	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),3),U$4:U$63,0))
S73	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),4),U$4:U$63,0))
S74	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),5),U$4:U$63,0))
S75	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),6),U$4:U$63,0))
S76	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),7),U$4:U$63,0))
S77	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),8),U$4:U$63,0))
S78	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),9),U$4:U$63,0))
S79	=INDEX(S$4:S$63,MATCH(LARGE((U$4:U$63),10),U$4:U$63,0))
T70	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),1),U$4:U$63,0))
T71	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),2),U$4:U$63,0))
T72	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),3),U$4:U$63,0))
T73	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),4),U$4:U$63,0))
T74	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),5),U$4:U$63,0))
T75	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),6),U$4:U$63,0))
T76	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),7),U$4:U$63,0))
T77	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),8),U$4:U$63,0))
T78	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),9),U$4:U$63,0))
T79	=INDEX(T$4:T$63,MATCH(LARGE((U$4:U$63),10),U$4:U$63,0))
U70	=LARGE(U$4:U$63,1)
U71	=LARGE(U$4:U$63,2)
U72	=LARGE(U$4:U$63,3)
U73	=LARGE(U$4:U$63,4)
U74	=LARGE(U$4:U$63,5)
U75	=LARGE(U$4:U$63,6)
U76	=LARGE(U$4:U$63,7)
U77	=LARGE(U$4:U$63,8)
U78	=LARGE(U$4:U$63,9)
U79	=LARGE(U$4:U$63,10)
V70	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),1),X$4:X$63,0))
V71	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),2),X$4:X$63,0))
V72	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),3),X$4:X$63,0))
V73	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),4),X$4:X$63,0))
V74	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),5),X$4:X$63,0))
V75	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),6),X$4:X$63,0))
V76	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),7),X$4:X$63,0))
V77	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),8),X$4:X$63,0))
V78	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),9),X$4:X$63,0))
V79	=INDEX(V$4:V$63,MATCH(LARGE((X$4:X$63),10),X$4:X$63,0))
W70	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),1),X$4:X$63,0))
W71	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),2),X$4:X$63,0))
W72	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),3),X$4:X$63,0))
W73	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),4),X$4:X$63,0))
W74	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),5),X$4:X$63,0))
W75	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),6),X$4:X$63,0))
W76	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),7),X$4:X$63,0))
W77	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),8),X$4:X$63,0))
W78	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),9),X$4:X$63,0))
W79	=INDEX(W$4:W$63,MATCH(LARGE((X$4:X$63),10),X$4:X$63,0))
X70	=LARGE(X$4:X$63,1)
X71	=LARGE(X$4:X$63,2)
X72	=LARGE(X$4:X$63,3)
X73	=LARGE(X$4:X$63,4)
X74	=LARGE(X$4:X$63,5)
X75	=LARGE(X$4:X$63,6)
X76	=LARGE(X$4:X$63,7)
X77	=LARGE(X$4:X$63,8)
X78	=LARGE(X$4:X$63,9)
X79	=LARGE(X$4:X$63,10)

 

[venkat1926]

try this formula
=INDEX(P$4:P$63,MATCH(LARGE((R$4:R$63),ROW(A1)),R$4:R$63,0))
and copy this formula down and check

 

[Aladin Akyurek]

Have a look at: http://www.mrexcel.com/forum/excel-questions/342541-top-5-numbers.html#post1690421

 

[jamada]

venkat1926, tks for your solution however have gone with the following;

Aladin Akyurek, thank you for your amazing solution, sorry I did not get back to thank either one of you earlier, this was way above me and I needed to get my head into it!
THANK YOU, Graham

 

[jamada]

Excel 2010
	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
64	TOP 10 - November - 2014
65
66		DH4			E75			Total Delays				DO NOT Touch
67		Secondary	QTY	Percent	Secondary	QTY	Percent	Secondary	QTY	Percent
68	1	MTF	9	19.1%	MTF	39	18.8%	MTF	48	18.8%		Top 10	19
69	2	FOR	6	12.8%	ISS	32	15.4%	ISS	35	13.7%		Large1	19
70	3	CNX	5	10.6%	SEB	18	8.7%	SEB	20	7.8%
71	4	ANB	3	6.4%	ANB	14	6.7%	ANB	17	6.7%		Top 10	31
72	5	IFO	3	6.4%	LOD	13	6.3%	IFT	13	5.1%		Large2	31
73	6	ISS	3	6.4%	IFT	12	5.8%	LOD	13	5.1%
74	7	ANG	2	4.3%	ANG	9	4.3%	ANG	11	4.3%		Top 10	35
75	8	FOX	2	4.3%	SES	7	3.4%	FOR	11	4.3%		Large3	35
76	9	MTP	2	4.3%	IFU	6	2.9%	IFO	8	3.1%
77	10	SEB	2	4.3%	ANF	5	2.4%	CNX	7	2.7%
78	11	PCH	2	4.3%	FOR	5	2.4%	IFU	7	2.7%
79	12	ANT	1	2.1%	IFO	5	2.4%	SES	7	2.7%
80	13	FOA	1	2.1%	MTR	5	2.4%	ANF	5	2.0%
81	14	IFT	1	2.1%	SEI	5	2.4%	MTR	5	2.0%
82	15	IFX	1	2.1%	SEE	5	2.4%	SEI	5	2.0%
83	16	IFU	1	2.1%	FOA	3	1.4%	SEE	5	2.0%
84	17	IFG	1	2.1%	FOE	3	1.4%	FOA	4	1.6%
85	18	MTH	1	2.1%	MTG	3	1.4%	FOX	4	1.6%
86	19	GNC	1	2.1%	CNX	2	1.0%	MTP	4	1.6%
87	20				FOX	2	1.0%	FOE	3	1.2%
88	21				FOC	2	1.0%	IFX	3	1.2%
89	22				IFX	2	1.0%	MTG	3	1.2%
90	23				MTP	2	1.0%	FOC	2	0.8%
91	24				MTM	2	1.0%	MTH	2	0.8%
92	25				FOU	1	0.5%	MTM	2	0.8%
93	26				MTH	1	0.5%	PCH	2	0.8%
94	27				ACT	1	0.5%	ANT	1	0.4%
95	28				ACU	1	0.5%	FOU	1	0.4%
96	29				ACG	1	0.5%	IFG	1	0.4%
97	30				APU	1	0.5%	ACT	1	0.4%
98	31				PSC	1	0.5%	ACU	1	0.4%
99	32							ACG	1	0.4%
100	33							APU	1	0.4%
101	34							PSC	1	0.4%
102	35							GNC	1	0.4%
103	36
NOVEMBER

Cell Formulas
Range	Formula
Q68	=IF(ROWS($Q$68:Q68)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q68)),"")
Q69	=IF(ROWS($Q$68:Q69)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q69)),"")
Q70	=IF(ROWS($Q$68:Q70)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q70)),"")
Q71	=IF(ROWS($Q$68:Q71)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q71)),"")
Q72	=IF(ROWS($Q$68:Q72)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q72)),"")
Q73	=IF(ROWS($Q$68:Q73)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q73)),"")
Q74	=IF(ROWS($Q$68:Q74)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q74)),"")
Q75	=IF(ROWS($Q$68:Q75)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q75)),"")
Q76	=IF(ROWS($Q$68:Q76)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q76)),"")
Q77	=IF(ROWS($Q$68:Q77)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q77)),"")
Q78	=IF(ROWS($Q$68:Q78)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q78)),"")
Q79	=IF(ROWS($Q$68:Q79)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q79)),"")
Q80	=IF(ROWS($Q$68:Q80)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q80)),"")
Q81	=IF(ROWS($Q$68:Q81)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q81)),"")
Q82	=IF(ROWS($Q$68:Q82)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q82)),"")
Q83	=IF(ROWS($Q$68:Q83)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q83)),"")
Q84	=IF(ROWS($Q$68:Q84)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q84)),"")
Q85	=IF(ROWS($Q$68:Q85)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q85)),"")
Q86	=IF(ROWS($Q$68:Q86)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q86)),"")
Q87	=IF(ROWS($Q$68:Q87)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q87)),"")
Q88	=IF(ROWS($Q$68:Q88)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q88)),"")
Q89	=IF(ROWS($Q$68:Q89)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q89)),"")
Q90	=IF(ROWS($Q$68:Q90)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q90)),"")
Q91	=IF(ROWS($Q$68:Q91)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q91)),"")
Q92	=IF(ROWS($Q$68:Q92)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q92)),"")
Q93	=IF(ROWS($Q$68:Q93)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q93)),"")
Q94	=IF(ROWS($Q$68:Q94)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q94)),"")
Q95	=IF(ROWS($Q$68:Q95)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q95)),"")
Q96	=IF(ROWS($Q$68:Q96)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q96)),"")
Q97	=IF(ROWS($Q$68:Q97)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q97)),"")
Q98	=IF(ROWS($Q$68:Q98)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q98)),"")
Q99	=IF(ROWS($Q$68:Q99)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q99)),"")
Q100	=IF(ROWS($Q$68:Q100)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q100)),"")
Q101	=IF(ROWS($Q$68:Q101)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q101)),"")
Q102	=IF(ROWS($Q$68:Q102)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q102)),"")
Q103	=IF(ROWS($Q$68:Q103)<=$AA$69,LARGE($Q$4:$Q$63,ROWS($Q$68:Q103)),"")
R68	=IF(ROWS($R$68:R68)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R68)),"")
R69	=IF(ROWS($R$68:R69)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R69)),"")
R70	=IF(ROWS($R$68:R70)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R70)),"")
R71	=IF(ROWS($R$68:R71)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R71)),"")
R72	=IF(ROWS($R$68:R72)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R72)),"")
R73	=IF(ROWS($R$68:R73)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R73)),"")
R74	=IF(ROWS($R$68:R74)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R74)),"")
R75	=IF(ROWS($R$68:R75)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R75)),"")
R76	=IF(ROWS($R$68:R76)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R76)),"")
R77	=IF(ROWS($R$68:R77)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R77)),"")
R78	=IF(ROWS($R$68:R78)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R78)),"")
R79	=IF(ROWS($R$68:R79)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R79)),"")
R80	=IF(ROWS($R$68:R80)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R80)),"")
R81	=IF(ROWS($R$68:R81)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R81)),"")
R82	=IF(ROWS($R$68:R82)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R82)),"")
R83	=IF(ROWS($R$68:R83)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R83)),"")
R84	=IF(ROWS($R$68:R84)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R84)),"")
R85	=IF(ROWS($R$68:R85)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R85)),"")
R86	=IF(ROWS($R$68:R86)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R86)),"")
R87	=IF(ROWS($R$68:R87)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R87)),"")
R88	=IF(ROWS($R$68:R88)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R88)),"")
R89	=IF(ROWS($R$68:R89)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R89)),"")
R90	=IF(ROWS($R$68:R90)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R90)),"")
R91	=IF(ROWS($R$68:R91)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R91)),"")
R92	=IF(ROWS($R$68:R92)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R92)),"")
R93	=IF(ROWS($R$68:R93)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R93)),"")
R94	=IF(ROWS($R$68:R94)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R94)),"")
R95	=IF(ROWS($R$68:R95)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R95)),"")
R96	=IF(ROWS($R$68:R96)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R96)),"")
R97	=IF(ROWS($R$68:R97)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R97)),"")
R98	=IF(ROWS($R$68:R98)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R98)),"")
R99	=IF(ROWS($R$68:R99)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R99)),"")
R100	=IF(ROWS($R$68:R100)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R100)),"")
R101	=IF(ROWS($R$68:R101)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R101)),"")
R102	=IF(ROWS($R$68:R102)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R102)),"")
R103	=IF(ROWS($R$68:R103)<=$AA$69,LARGE($R$4:$R$63,ROWS($R$68:R103)),"")
T68	=IF(ROWS($T$68:T68)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T68)),"")
T69	=IF(ROWS($T$68:T69)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T69)),"")
T70	=IF(ROWS($T$68:T70)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T70)),"")
T71	=IF(ROWS($T$68:T71)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T71)),"")
T72	=IF(ROWS($T$68:T72)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T72)),"")
T73	=IF(ROWS($T$68:T73)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T73)),"")
T74	=IF(ROWS($T$68:T74)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T74)),"")
T75	=IF(ROWS($T$68:T75)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T75)),"")
T76	=IF(ROWS($T$68:T76)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T76)),"")
T77	=IF(ROWS($T$68:T77)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T77)),"")
T78	=IF(ROWS($T$68:T78)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T78)),"")
T79	=IF(ROWS($T$68:T79)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T79)),"")
T80	=IF(ROWS($T$68:T80)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T80)),"")
T81	=IF(ROWS($T$68:T81)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T81)),"")
T82	=IF(ROWS($T$68:T82)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T82)),"")
T83	=IF(ROWS($T$68:T83)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T83)),"")
T84	=IF(ROWS($T$68:T84)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T84)),"")
T85	=IF(ROWS($T$68:T85)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T85)),"")
T86	=IF(ROWS($T$68:T86)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T86)),"")
T87	=IF(ROWS($T$68:T87)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T87)),"")
T88	=IF(ROWS($T$68:T88)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T88)),"")
T89	=IF(ROWS($T$68:T89)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T89)),"")
T90	=IF(ROWS($T$68:T90)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T90)),"")
T91	=IF(ROWS($T$68:T91)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T91)),"")
T92	=IF(ROWS($T$68:T92)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T92)),"")
T93	=IF(ROWS($T$68:T93)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T93)),"")
T94	=IF(ROWS($T$68:T94)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T94)),"")
T95	=IF(ROWS($T$68:T95)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T95)),"")
T96	=IF(ROWS($T$68:T96)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T96)),"")
T97	=IF(ROWS($T$68:T97)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T97)),"")
T98	=IF(ROWS($T$68:T98)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T98)),"")
T99	=IF(ROWS($T$68:T99)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T99)),"")
T100	=IF(ROWS($T$68:T100)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T100)),"")
T101	=IF(ROWS($T$68:T101)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T101)),"")
T102	=IF(ROWS($T$68:T102)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T102)),"")
T103	=IF(ROWS($T$68:T103)<=$AA$71,LARGE($T$4:$T$63,ROWS($T$68:T103)),"")
U68	=IF(ROWS($U$68:U68)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U68)),"")
U69	=IF(ROWS($U$68:U69)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U69)),"")
U70	=IF(ROWS($U$68:U70)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U70)),"")
U71	=IF(ROWS($U$68:U71)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U71)),"")
U72	=IF(ROWS($U$68:U72)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U72)),"")
U73	=IF(ROWS($U$68:U73)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U73)),"")
U74	=IF(ROWS($U$68:U74)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U74)),"")
U75	=IF(ROWS($U$68:U75)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U75)),"")
U76	=IF(ROWS($U$68:U76)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U76)),"")
U77	=IF(ROWS($U$68:U77)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U77)),"")
U78	=IF(ROWS($U$68:U78)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U78)),"")
U79	=IF(ROWS($U$68:U79)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U79)),"")
U80	=IF(ROWS($U$68:U80)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U80)),"")
U81	=IF(ROWS($U$68:U81)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U81)),"")
U82	=IF(ROWS($U$68:U82)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U82)),"")
U83	=IF(ROWS($U$68:U83)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U83)),"")
U84	=IF(ROWS($U$68:U84)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U84)),"")
U85	=IF(ROWS($U$68:U85)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U85)),"")
U86	=IF(ROWS($U$68:U86)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U86)),"")
U87	=IF(ROWS($U$68:U87)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U87)),"")
U88	=IF(ROWS($U$68:U88)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U88)),"")
U89	=IF(ROWS($U$68:U89)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U89)),"")
U90	=IF(ROWS($U$68:U90)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U90)),"")
U91	=IF(ROWS($U$68:U91)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U91)),"")
U92	=IF(ROWS($U$68:U92)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U92)),"")
U93	=IF(ROWS($U$68:U93)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U93)),"")
U94	=IF(ROWS($U$68:U94)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U94)),"")
U95	=IF(ROWS($U$68:U95)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U95)),"")
U96	=IF(ROWS($U$68:U96)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U96)),"")
U97	=IF(ROWS($U$68:U97)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U97)),"")
U98	=IF(ROWS($U$68:U98)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U98)),"")
U99	=IF(ROWS($U$68:U99)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U99)),"")
U100	=IF(ROWS($U$68:U100)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U100)),"")
U101	=IF(ROWS($U$68:U101)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U101)),"")
U102	=IF(ROWS($U$68:U102)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U102)),"")
U103	=IF(ROWS($U$68:U103)<=$AA$71,LARGE($U$4:$U$63,ROWS($U$68:U103)),"")
W68	=IF(ROWS($W$68:W68)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W68)),"")
W69	=IF(ROWS($W$68:W69)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W69)),"")
W70	=IF(ROWS($W$68:W70)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W70)),"")
W71	=IF(ROWS($W$68:W71)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W71)),"")
W72	=IF(ROWS($W$68:W72)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W72)),"")
W73	=IF(ROWS($W$68:W73)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W73)),"")
W74	=IF(ROWS($W$68:W74)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W74)),"")
W75	=IF(ROWS($W$68:W75)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W75)),"")
W76	=IF(ROWS($W$68:W76)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W76)),"")
W77	=IF(ROWS($W$68:W77)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W77)),"")
W78	=IF(ROWS($W$68:W78)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W78)),"")
W79	=IF(ROWS($W$68:W79)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W79)),"")
W80	=IF(ROWS($W$68:W80)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W80)),"")
W81	=IF(ROWS($W$68:W81)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W81)),"")
W82	=IF(ROWS($W$68:W82)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W82)),"")
W83	=IF(ROWS($W$68:W83)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W83)),"")
W84	=IF(ROWS($W$68:W84)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W84)),"")
W85	=IF(ROWS($W$68:W85)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W85)),"")
W86	=IF(ROWS($W$68:W86)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W86)),"")
W87	=IF(ROWS($W$68:W87)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W87)),"")
W88	=IF(ROWS($W$68:W88)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W88)),"")
W89	=IF(ROWS($W$68:W89)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W89)),"")
W90	=IF(ROWS($W$68:W90)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W90)),"")
W91	=IF(ROWS($W$68:W91)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W91)),"")
W92	=IF(ROWS($W$68:W92)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W92)),"")
W93	=IF(ROWS($W$68:W93)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W93)),"")
W94	=IF(ROWS($W$68:W94)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W94)),"")
W95	=IF(ROWS($W$68:W95)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W95)),"")
W96	=IF(ROWS($W$68:W96)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W96)),"")
W97	=IF(ROWS($W$68:W97)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W97)),"")
W98	=IF(ROWS($W$68:W98)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W98)),"")
W99	=IF(ROWS($W$68:W99)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W99)),"")
W100	=IF(ROWS($W$68:W100)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W100)),"")
W101	=IF(ROWS($W$68:W101)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W101)),"")
W102	=IF(ROWS($W$68:W102)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W102)),"")
W103	=IF(ROWS($W$68:W103)<=$AA$74,LARGE($W$4:$W$63,ROWS($W$68:W103)),"")
X68	=IF(ROWS($X$68:X68)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X68)),"")
X69	=IF(ROWS($X$68:X69)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X69)),"")
X70	=IF(ROWS($X$68:X70)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X70)),"")
X71	=IF(ROWS($X$68:X71)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X71)),"")
X72	=IF(ROWS($X$68:X72)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X72)),"")
X73	=IF(ROWS($X$68:X73)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X73)),"")
X74	=IF(ROWS($X$68:X74)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X74)),"")
X75	=IF(ROWS($X$68:X75)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X75)),"")
X76	=IF(ROWS($X$68:X76)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X76)),"")
X77	=IF(ROWS($X$68:X77)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X77)),"")
X78	=IF(ROWS($X$68:X78)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X78)),"")
X79	=IF(ROWS($X$68:X79)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X79)),"")
X80	=IF(ROWS($X$68:X80)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X80)),"")
X81	=IF(ROWS($X$68:X81)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X81)),"")
X82	=IF(ROWS($X$68:X82)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X82)),"")
X83	=IF(ROWS($X$68:X83)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X83)),"")
X84	=IF(ROWS($X$68:X84)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X84)),"")
X85	=IF(ROWS($X$68:X85)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X85)),"")
X86	=IF(ROWS($X$68:X86)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X86)),"")
X87	=IF(ROWS($X$68:X87)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X87)),"")
X88	=IF(ROWS($X$68:X88)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X88)),"")
X89	=IF(ROWS($X$68:X89)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X89)),"")
X90	=IF(ROWS($X$68:X90)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X90)),"")
X91	=IF(ROWS($X$68:X91)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X91)),"")
X92	=IF(ROWS($X$68:X92)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X92)),"")
X93	=IF(ROWS($X$68:X93)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X93)),"")
X94	=IF(ROWS($X$68:X94)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X94)),"")
X95	=IF(ROWS($X$68:X95)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X95)),"")
X96	=IF(ROWS($X$68:X96)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X96)),"")
X97	=IF(ROWS($X$68:X97)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X97)),"")
X98	=IF(ROWS($X$68:X98)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X98)),"")
X99	=IF(ROWS($X$68:X99)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X99)),"")
X100	=IF(ROWS($X$68:X100)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X100)),"")
X101	=IF(ROWS($X$68:X101)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X101)),"")
X102	=IF(ROWS($X$68:X102)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X102)),"")
X103	=IF(ROWS($X$68:X103)<=$AA$74,LARGE($X$4:$X$63,ROWS($X$68:X103)),"")
AA68	=COUNTIF(Q4:Q63,">0")
AA69	=COUNTIF(R4:R63,">="&LARGE(R4:R63,AA68))
AA71	=COUNTIF(T4:T63,">0")
AA72	=COUNTIF(U4:U63,">="&LARGE(U4:U63,AA71))
AA74	=COUNTIF(W4:W63,">0")
AA75	=COUNTIF(X4:X63,">="&LARGE(X4:X63,AA74))
P68	{=IF(N(R68),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R68,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R68,R68))),"")}
P69	{=IF(N(R69),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R69,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R69,R69))),"")}
P70	{=IF(N(R70),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R70,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R70,R70))),"")}
P71	{=IF(N(R71),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R71,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R71,R71))),"")}
P72	{=IF(N(R72),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R72,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R72,R72))),"")}
P73	{=IF(N(R73),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R73,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R73,R73))),"")}
P74	{=IF(N(R74),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R74,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R74,R74))),"")}
P75	{=IF(N(R75),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R75,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R75,R75))),"")}
P76	{=IF(N(R76),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R76,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R76,R76))),"")}
P77	{=IF(N(R77),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R77,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R77,R77))),"")}
P78	{=IF(N(R78),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R78,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R78,R78))),"")}
P79	{=IF(N(R79),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R79,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R79,R79))),"")}
P80	{=IF(N(R80),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R80,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R80,R80))),"")}
P81	{=IF(N(R81),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R81,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R81,R81))),"")}
P82	{=IF(N(R82),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R82,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R82,R82))),"")}
P83	{=IF(N(R83),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R83,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R83,R83))),"")}
P84	{=IF(N(R84),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R84,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R84,R84))),"")}
P85	{=IF(N(R85),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R85,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R85,R85))),"")}
P86	{=IF(N(R86),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R86,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R86,R86))),"")}
P87	{=IF(N(R87),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R87,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R87,R87))),"")}
P88	{=IF(N(R88),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R88,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R88,R88))),"")}
P89	{=IF(N(R89),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R89,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R89,R89))),"")}
P90	{=IF(N(R90),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R90,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R90,R90))),"")}
P91	{=IF(N(R91),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R91,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R91,R91))),"")}
P92	{=IF(N(R92),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R92,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R92,R92))),"")}
P93	{=IF(N(R93),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R93,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R93,R93))),"")}
P94	{=IF(N(R94),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R94,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R94,R94))),"")}
P95	{=IF(N(R95),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R95,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R95,R95))),"")}
P96	{=IF(N(R96),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R96,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R96,R96))),"")}
P97	{=IF(N(R97),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R97,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R97,R97))),"")}
P98	{=IF(N(R98),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R98,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R98,R98))),"")}
P99	{=IF(N(R99),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R99,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R99,R99))),"")}
P100	{=IF(N(R100),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R100,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R100,R100))),"")}
P101	{=IF(N(R101),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R101,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R101,R101))),"")}
P102	{=IF(N(R102),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R102,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R102,R102))),"")}
P103	{=IF(N(R103),INDEX($P$4:$P$63,SMALL(IF($R$4:$R$63=R103,ROW($R$4:$R$63)-ROW($R$4)+1),COUNTIF($R$68:R103,R103))),"")}
S68	{=IF(N(U68),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U68,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U68,U68))),"")}
S69	{=IF(N(U69),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U69,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U69,U69))),"")}
S70	{=IF(N(U70),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U70,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U70,U70))),"")}
S71	{=IF(N(U71),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U71,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U71,U71))),"")}
S72	{=IF(N(U72),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U72,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U72,U72))),"")}
S73	{=IF(N(U73),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U73,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U73,U73))),"")}
S74	{=IF(N(U74),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U74,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U74,U74))),"")}
S75	{=IF(N(U75),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U75,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U75,U75))),"")}
S76	{=IF(N(U76),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U76,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U76,U76))),"")}
S77	{=IF(N(U77),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U77,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U77,U77))),"")}
S78	{=IF(N(U78),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U78,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U78,U78))),"")}
S79	{=IF(N(U79),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U79,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U79,U79))),"")}
S80	{=IF(N(U80),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U80,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U80,U80))),"")}
S81	{=IF(N(U81),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U81,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U81,U81))),"")}
S82	{=IF(N(U82),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U82,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U82,U82))),"")}
S83	{=IF(N(U83),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U83,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U83,U83))),"")}
S84	{=IF(N(U84),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U84,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U84,U84))),"")}
S85	{=IF(N(U85),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U85,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U85,U85))),"")}
S86	{=IF(N(U86),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U86,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U86,U86))),"")}
S87	{=IF(N(U87),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U87,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U87,U87))),"")}
S88	{=IF(N(U88),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U88,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U88,U88))),"")}
S89	{=IF(N(U89),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U89,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U89,U89))),"")}
S90	{=IF(N(U90),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U90,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U90,U90))),"")}
S91	{=IF(N(U91),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U91,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U91,U91))),"")}
S92	{=IF(N(U92),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U92,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U92,U92))),"")}
S93	{=IF(N(U93),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U93,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U93,U93))),"")}
S94	{=IF(N(U94),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U94,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U94,U94))),"")}
S95	{=IF(N(U95),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U95,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U95,U95))),"")}
S96	{=IF(N(U96),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U96,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U96,U96))),"")}
S97	{=IF(N(U97),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U97,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U97,U97))),"")}
S98	{=IF(N(U98),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U98,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U98,U98))),"")}
S99	{=IF(N(U99),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U99,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U99,U99))),"")}
S100	{=IF(N(U100),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U100,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U100,U100))),"")}
S101	{=IF(N(U101),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U101,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U101,U101))),"")}
S102	{=IF(N(U102),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U102,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U102,U102))),"")}
S103	{=IF(N(U103),INDEX($S$4:$S$63,SMALL(IF($U$4:$U$63=U103,ROW($U$4:$U$63)-ROW($U$4)+1),COUNTIF($U$68:U103,U103))),"")}
V68	{=IF(N(X68),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X68,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X68,X68))),"")}
V69	{=IF(N(X69),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X69,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X69,X69))),"")}
V70	{=IF(N(X70),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X70,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X70,X70))),"")}
V71	{=IF(N(X71),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X71,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X71,X71))),"")}
V72	{=IF(N(X72),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X72,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X72,X72))),"")}
V73	{=IF(N(X73),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X73,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X73,X73))),"")}
V74	{=IF(N(X74),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X74,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X74,X74))),"")}
V75	{=IF(N(X75),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X75,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X75,X75))),"")}
V76	{=IF(N(X76),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X76,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X76,X76))),"")}
V77	{=IF(N(X77),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X77,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X77,X77))),"")}
V78	{=IF(N(X78),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X78,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X78,X78))),"")}
V79	{=IF(N(X79),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X79,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X79,X79))),"")}
V80	{=IF(N(X80),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X80,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X80,X80))),"")}
V81	{=IF(N(X81),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X81,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X81,X81))),"")}
V82	{=IF(N(X82),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X82,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X82,X82))),"")}
V83	{=IF(N(X83),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X83,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X83,X83))),"")}
V84	{=IF(N(X84),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X84,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X84,X84))),"")}
V85	{=IF(N(X85),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X85,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X85,X85))),"")}
V86	{=IF(N(X86),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X86,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X86,X86))),"")}
V87	{=IF(N(X87),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X87,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X87,X87))),"")}
V88	{=IF(N(X88),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X88,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X88,X88))),"")}
V89	{=IF(N(X89),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X89,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X89,X89))),"")}
V90	{=IF(N(X90),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X90,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X90,X90))),"")}
V91	{=IF(N(X91),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X91,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X91,X91))),"")}
V92	{=IF(N(X92),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X92,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X92,X92))),"")}
V93	{=IF(N(X93),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X93,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X93,X93))),"")}
V94	{=IF(N(X94),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X94,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X94,X94))),"")}
V95	{=IF(N(X95),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X95,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X95,X95))),"")}
V96	{=IF(N(X96),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X96,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X96,X96))),"")}
V97	{=IF(N(X97),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X97,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X97,X97))),"")}
V98	{=IF(N(X98),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X98,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X98,X98))),"")}
V99	{=IF(N(X99),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X99,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X99,X99))),"")}
V100	{=IF(N(X100),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X100,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X100,X100))),"")}
V101	{=IF(N(X101),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X101,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X101,X101))),"")}
V102	{=IF(N(X102),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X102,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X102,X102))),"")}
V103	{=IF(N(X103),INDEX($V$4:$V$63,SMALL(IF($X$4:$X$63=X103,ROW($X$4:$X$63)-ROW($X$4)+1),COUNTIF($X$68:X103,X103))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Aladin Akyurek]

venkat1926, tks for your solution however have gone with the following;

Aladin Akyurek, thank you for your amazing solution, sorry I did not get back to thank either one of you earlier, this was way above me and I needed to get my head into it!
THANK YOU, Graham

You are welcome. Note that you don't have to print all of the formula repetitions.