INDEX MATCH LARGE ... How To Avoid Duplicates?

jamada

Active Member
Joined
Mar 23, 2006
Messages
323
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



Cell Formulas
RangeFormula
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)
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
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
 
Upvote 0
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
 
Upvote 0

Cell Formulas
RangeFormula
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top