Try the array formulas below and tell me if works:
Code:
Use Ctrl+Shift+Enter and not only Enter to enter the formula
=INDEX(P2P!$A$2:$A$5943,MATCH(SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1),IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),0))
=SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1)
Layout
[TABLE="width: 462"]
<TBODY>[TR]
[TD="class: xl65, width: 47, bgcolor: transparent"]
Origin
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]
Key
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]
Destination
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]
Top carrier1
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]
Top Rate1
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]
Top carrier2
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]
Top Rate2
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]
Top carrier3
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]
Top Rate3
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]
Top P2P
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
TX
[/TD]
[TD="class: xl65, bgcolor: transparent"]
TX-NY
[/TD]
[TD="class: xl65, bgcolor: transparent"]
NY
[/TD]
[TD="class: xl66, bgcolor: yellow"]
APEX
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,25
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Coyote
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,29
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Merit
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,48
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]
OK-NY
[/TD]
[TD="class: xl65, bgcolor: transparent"]
NY
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Coyote
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
3,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]
APEX
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
3,60
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Merit
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
5,00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
TK
[/TD]
[TD="class: xl65, bgcolor: transparent"]
TK-NY1
[/TD]
[TD="class: xl65, bgcolor: transparent"]
NY1
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
TK
[/TD]
[TD="class: xl65, bgcolor: transparent"]
TK-NY2
[/TD]
[TD="class: xl65, bgcolor: transparent"]
NY2
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier103
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier544
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier544
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,02
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]
OK-NY2
[/TD]
[TD="class: xl65, bgcolor: transparent"]
NY2
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,02
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]
OK-NY1
[/TD]
[TD="class: xl65, bgcolor: transparent"]
NY1
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier374
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier374
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]
Carrier314
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]
1,01
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]
********
[/TD]
[TD="class: xl65, bgcolor: transparent"]
************
[/TD]
[TD="class: xl65, bgcolor: transparent"]
************
[/TD]
[TD="class: xl65, bgcolor: transparent"]
************
[/TD]
[TD="class: xl65, bgcolor: transparent"]
**********
[/TD]
[TD="class: xl65, bgcolor: transparent"]
************
[/TD]
[TD="class: xl65, bgcolor: transparent"]
**********
[/TD]
[TD="class: xl65, bgcolor: transparent"]
************
[/TD]
[TD="class: xl65, bgcolor: transparent"]
**********
[/TD]
[TD="class: xl69, bgcolor: transparent"]
********
[/TD]
[/TR]
</TBODY>[/TABLE]
Markmzz