index/match to show high number to low number

[njlevi49]

In column b I use =INDEX($E$3:$E$21,MATCH(C3,$F$3:$F$21,0)) and column c I use =LARGE($F$3:$F$21,ROW(F2)) as you see if the numbers are the same it pulls the first set of name in the e column and their are someof the name missing. I am trying to match the names in column b with numbers in column c all data pulled from columns e and f. Any ideas on how to resolve to make this work. Thanks

[TABLE="width: 427"]
<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;" width="25"> <col style="width: 147pt; mso-width-source: userset; mso-width-alt: 7168;" width="196"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 48pt;" width="64"> <col style="width: 143pt; mso-width-source: userset; mso-width-alt: 6948;" width="190"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <tbody>[TR]
[TD="class: xl73, width: 25, bgcolor: #C5D9F1"]A[/TD]
[TD="class: xl73, width: 196, bgcolor: #C5D9F1"]B[/TD]
[TD="class: xl73, width: 46, bgcolor: #C5D9F1"]C[/TD]
[TD="class: xl73, width: 64, bgcolor: #C5D9F1"]D[/TD]
[TD="class: xl73, width: 190, bgcolor: #C5D9F1"]E[/TD]
[TD="class: xl73, width: 46, bgcolor: #C5D9F1"]F[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]Team Ranking[/TD]
[TD="class: xl72, bgcolor: transparent"]Points[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Team Ranking[/TD]
[TD="class: xl69, bgcolor: transparent"]Points[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]14 Milnamow/Batcheider[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]18.5[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1 Isbister/Howe[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]15[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]6 Emeott/Hahn[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]18[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2 Fitch/Poet[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]8 Budd/Rudnick[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]16[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3 Hanlon/Dougherty[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]1 Isbister/Howe[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4 Ponkey/Levi[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]18 Conway/Daughtery[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]14[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]5 Raukar/Itami[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]7[/TD]
[TD="class: xl69, bgcolor: transparent"]16 Barker/Supron[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]13[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]6 Emeott/Hahn[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]18[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]8[/TD]
[TD="class: xl69, bgcolor: transparent"]9 Friedrichs/Dennis[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]7 Grodzicki/Campau[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]9[/TD]
[TD="class: xl69, bgcolor: transparent"]11 Patterson/Dattilo[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]8 Budd/Rudnick[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]16[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]10[/TD]
[TD="class: xl69, bgcolor: transparent"]11 Patterson/Dattilo[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]9 Friedrichs/Dennis[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]11[/TD]
[TD="class: xl69, bgcolor: transparent"]10 Gohl/Thompson[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]10 Gohl/Thompson[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]12[/TD]
[TD="class: xl69, bgcolor: transparent"]15 Thomas/Coates[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]11 Patterson/Dattilo[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]13[/TD]
[TD="class: xl69, bgcolor: transparent"]17 Curry/Karoub[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]12 Grodzicki/Scott[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]14[/TD]
[TD="class: xl69, bgcolor: transparent"]2 Fitch/Poet[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]13 Hiller/Mudie[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]15[/TD]
[TD="class: xl69, bgcolor: transparent"]7 Grodzicki/Campau[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]14 Milnamow/Batcheider[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]18.5[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]16[/TD]
[TD="class: xl69, bgcolor: transparent"]5 Raukar/Itami[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]15 Thomas/Coates[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]17[/TD]
[TD="class: xl69, bgcolor: transparent"]5 Raukar/Itami[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]16 Barker/Supron[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]13[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #C5D9F1, align: right"]18[/TD]
[TD="class: xl70, bgcolor: transparent"]3 Hanlon/Dougherty[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]17 Curry/Karoub[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #C5D9F1, align: right"]19[/TD]
[TD="class: xl69, bgcolor: transparent"]3 Hanlon/Dougherty[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]18 Conway/Daughtery[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]14[/TD]
[/TR]
</tbody>[/TABLE]

 

[njlevi49]

This worked Thanks I have another simular sheet that requires ranking but it would be ranked from 9 to 1 High to low but it has to add up to 45. I am not sure how to do that when I have ties (see below) Row 1 and 2 would be 8.5 each The end result would to total 45
[TABLE="width: 199"]
<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 711;" width="25"> <col style="width: 60pt;" span="3" width="80"> <tbody>[TR]
[TD="class: xl70, width: 25, bgcolor: #C5D9F1"] [/TD]
[TD="class: xl71, width: 80, bgcolor: #C5D9F1"]A[/TD]
[TD="class: xl71, width: 80, bgcolor: #C5D9F1"]B[/TD]
[TD="class: xl71, width: 80, bgcolor: #C5D9F1"]C[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]Friedrichs, Reid [/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]34[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]2[/TD]
[TD="class: xl72, bgcolor: transparent"]Patterson, Pat[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]34[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]8[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]3[/TD]
[TD="class: xl72, bgcolor: transparent"]Grodzicki, Matt[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]37[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]7[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]4[/TD]
[TD="class: xl72, bgcolor: transparent"] Campau, Chad[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]36[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]5[/TD]
[TD="class: xl72, bgcolor: transparent"]Dougherty Jack[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]38[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]6[/TD]
[TD="class: xl72, bgcolor: transparent"]Dattilo, Mike[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]38[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]7[/TD]
[TD="class: xl72, bgcolor: transparent"]Dennis, Brad[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]38[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]8[/TD]
[TD="class: xl72, bgcolor: transparent"]Hanlon, Ed [/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]39[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: #C5D9F1, align: right"]9[/TD]
[TD="class: xl72, bgcolor: transparent"]Fitch, Mark [/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]40[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]45[/TD]
[/TR]
</tbody>[/TABLE]

 

[meldoc]

Hi

I'm not sure I understand what you are asking, could you post some data showing before and after examples.
Also what version of Excel are you using, you seem to be using RANK.AVG, and in the example that you posted the results you show in B3:B4 don't match those in C3:C4.