Ranking Sub Groups in a Table

[thenapolitan]

Hey All,

I am currently looking at trying to do some ranking within some sub-groups in a table I am working with. Here is the table:

[TABLE="width: 1338"]
<colgroup><col span="2"><col><col><col><col><col span="3"><col></colgroup><tbody>[TR]
[TD]Current Rank[/TD]
[TD]Man[/TD]
[TD]Name[/TD]
[TD]Team #[/TD]
[TD]Team[/TD]
[TD]Starting Rank[/TD]
[TD]Match Wins[/TD]
[TD]Match Losses[/TD]
[TD]Matches Played[/TD]
[TD]Match WL %[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]Craig Bensch[/TD]
[TD]1[/TD]
[TD]Kalir Farms[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]12[/TD]
[TD]67%[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Dom Sanzotta Jr.[/TD]
[TD]1[/TD]
[TD]Kalir Farms[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]12[/TD]
[TD]67%[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]Oded Kalir[/TD]
[TD]1[/TD]
[TD]Kalir Farms[/TD]
[TD]21[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]12[/TD]
[TD]33%[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]1[/TD]
[TD]Des Preston[/TD]
[TD]2[/TD]
[TD]NiColoy[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]12[/TD]
[TD]33%[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]Roger Haidvogel[/TD]
[TD]2[/TD]
[TD]NiColoy[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]3[/TD]
[TD]Dan Emord[/TD]
[TD]2[/TD]
[TD]NiColoy[/TD]
[TD]23[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]16[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]Wayne Carney[/TD]
[TD]6[/TD]
[TD]Erb Financial[/TD]
[TD]6[/TD]
[TD]20[/TD]
[TD]4[/TD]
[TD]24[/TD]
[TD]83%[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[TD]Ben Clark[/TD]
[TD]6[/TD]
[TD]Erb Financial[/TD]
[TD]18[/TD]
[TD]8[/TD]
[TD]16[/TD]
[TD]24[/TD]
[TD]33%[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]3[/TD]
[TD]Terry Black[/TD]
[TD]6[/TD]
[TD]Erb Financial[/TD]
[TD]30[/TD]
[TD]8[/TD]
[TD]16[/TD]
[TD]24[/TD]
[TD]33%[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]Jamie Barnhart[/TD]
[TD]12[/TD]
[TD]Apartment Finder Renters Guide[/TD]
[TD]16[/TD]
[TD]20[/TD]
[TD]4[/TD]
[TD]24[/TD]
[TD]83%[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2[/TD]
[TD]Yogi Pulla[/TD]
[TD]12[/TD]
[TD]Apartment Finder Renters Guide[/TD]
[TD]28[/TD]
[TD]8[/TD]
[TD]16[/TD]
[TD]24[/TD]
[TD]33%[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]3[/TD]
[TD]Dom Sanzotta Sr.[/TD]
[TD]12[/TD]
[TD]Apartment Finder Renters Guide[/TD]
[TD]36[/TD]
[TD]8[/TD]
[TD]16[/TD]
[TD]24[/TD]
[TD]33%[/TD]
[/TR]
</tbody>[/TABLE]


As you can see, there are 3 players per team (a 1 man, 2 man, and 3 man). What I want to do is rank all of the 1 players, 2 players and 3 players separately - then do a VLOOKUP based on their name to autosort the following 3 tables based on their score changes, but only for the sub-groups of each "man" or player. Below are tables for examples, but what I am looking for is a function to try to get the name of the player into the "Player Name" in the tables below (then do VLOOKUP to bring the rest of the information in).

I wouldn't be opposed to adding another column to the table above, adding the player rank, then using some search criteria to bring their names auto-sorted into the tables below, but I'm at a loss here. Anyone have any ideas? Let me know if I am not being clear and I will clarify as much as possible.

[TABLE="width: 1131"]
<colgroup><col span="2"><col><col><col span="7"></colgroup><tbody>[TR]
[TD]1 Man Rank[/TD]
[TD]Team Number[/TD]
[TD]Team Name[/TD]
[TD]Player Name[/TD]
[TD]1 Man Match Wins[/TD]
[TD]1 Man Match Losses[/TD]
[TD]1 Man MWL%[/TD]
[TD]1 Man Game Wins[/TD]
[TD]1 Man Game Losses[/TD]
[TD]1 Man GWL%[/TD]
[TD]Overall Rank[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]Des Preston[/TD]
[TD]35[/TD]
[TD]1[/TD]
[TD]97.22%[/TD]
[TD]143[/TD]
[TD]20[/TD]
[TD]87.73%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]Craig Bensch[/TD]
[TD]26[/TD]
[TD]1[/TD]
[TD]96.30%[/TD]
[TD]107[/TD]
[TD]20[/TD]
[TD]84.25%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]Ray Mack[/TD]
[TD]29[/TD]
[TD]4[/TD]
[TD]87.88%[/TD]
[TD]124[/TD]
[TD]38[/TD]
[TD]76.54%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]Wei Zou[/TD]
[TD]29[/TD]
[TD]4[/TD]
[TD]87.88%[/TD]
[TD]125[/TD]
[TD]39[/TD]
[TD]76.22%[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1131"]
<colgroup><col span="2"><col><col><col span="7"></colgroup><tbody>[TR]
[TD]2 Man Rank[/TD]
[TD]Team Number[/TD]
[TD]Team Name[/TD]
[TD]Player Name[/TD]
[TD]2 Man Match Wins[/TD]
[TD]2 Man Match Losses[/TD]
[TD]2 Man MWL%[/TD]
[TD]2 Man Game Wins[/TD]
[TD]2 Man Game Losses[/TD]
[TD]2 Man GWL%[/TD]
[TD]Overall Rank[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9[/TD]
[TD] [/TD]
[TD]Roger Haidvogel[/TD]
[TD]23[/TD]
[TD]13[/TD]
[TD]63.89%[/TD]
[TD]99[/TD]
[TD]75[/TD]
[TD]56.90%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD] [/TD]
[TD]Sri Ramaswamy[/TD]
[TD]18[/TD]
[TD]12[/TD]
[TD]60.00%[/TD]
[TD]82[/TD]
[TD]73[/TD]
[TD]52.90%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]11[/TD]
[TD] [/TD]
[TD]Marc Maronian[/TD]
[TD]19[/TD]
[TD]14[/TD]
[TD]57.58%[/TD]
[TD]92[/TD]
[TD]78[/TD]
[TD]54.12%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]Pauli Orr[/TD]
[TD]18[/TD]
[TD]15[/TD]
[TD]54.55%[/TD]
[TD]89[/TD]
[TD]85[/TD]
[TD]51.15%[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1131"]
<colgroup><col span="2"><col><col><col span="7"></colgroup><tbody>[TR]
[TD]3 Man Rank[/TD]
[TD]Team Number[/TD]
[TD]Team Name[/TD]
[TD]Player Name[/TD]
[TD]3 Man Match Wins[/TD]
[TD]3 Man Match Losses[/TD]
[TD]3 Man MWL%[/TD]
[TD]3 Man Game Wins[/TD]
[TD]3 Man Game Losses[/TD]
[TD]3 Man GWL%[/TD]
[TD]Overall Rank[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9[/TD]
[TD] [/TD]
[TD]Oded Kalir[/TD]
[TD]14[/TD]
[TD]10[/TD]
[TD]58.33%[/TD]
[TD]66[/TD]
[TD]59[/TD]
[TD]52.80%[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD]Mike Brown[/TD]
[TD]20[/TD]
[TD]16[/TD]
[TD]55.56%[/TD]
[TD]101[/TD]
[TD]96[/TD]
[TD]51.27%[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]Marty Salata[/TD]
[TD]13[/TD]
[TD]20[/TD]
[TD]39.39%[/TD]
[TD]72[/TD]
[TD]89[/TD]
[TD]44.72%[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]11[/TD]
[TD] [/TD]
[TD]Kock Yee Law[/TD]
[TD]13[/TD]
[TD]23[/TD]
[TD]36.11%[/TD]
[TD]79[/TD]
[TD]105[/TD]
[TD]42.93%[/TD]
[TD]26[/TD]
[/TR]
</tbody>[/TABLE]


Thanks so much to anyone who can help with this!

Cheers,

Chris