Ranking Sub Groups in a Table

thenapolitan

Board Regular
Joined
Sep 5, 2014
Messages
52
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
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,222,441
Messages
6,166,052
Members
452,010
Latest member
triangle3

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