# Ranking Sub Groups in a Table

#### thenapolitan

##### Board Regular
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:

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

<colgroup><col span="2"><col><col><col><col><col span="3"><col></colgroup><tbody>
</tbody>

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.

 1 Man Rank Team Number Team Name Player Name 1 Man Match Wins 1 Man Match Losses 1 Man MWL% 1 Man Game Wins 1 Man Game Losses 1 Man GWL% Overall Rank 1 2 Des Preston 35 1 97.22% 143 20 87.73% 2 1 Craig Bensch 26 1 96.30% 107 20 84.25% 3 7 Ray Mack 29 4 87.88% 124 38 76.54% 4 5 Wei Zou 29 4 87.88% 125 39 76.22%

<colgroup><col span="2"><col><col><col span="7"></colgroup><tbody>
</tbody>

 2 Man Rank Team Number Team Name Player Name 2 Man Match Wins 2 Man Match Losses 2 Man MWL% 2 Man Game Wins 2 Man Game Losses 2 Man GWL% Overall Rank 1 9 Roger Haidvogel 23 13 63.89% 99 75 56.90% 2 10 Sri Ramaswamy 18 12 60.00% 82 73 52.90% 3 11 Marc Maronian 19 14 57.58% 92 78 54.12% 4 2 Pauli Orr 18 15 54.55% 89 85 51.15%

<colgroup><col span="2"><col><col><col span="7"></colgroup><tbody>
</tbody>

 3 Man Rank Team Number Team Name Player Name 3 Man Match Wins 3 Man Match Losses 3 Man MWL% 3 Man Game Wins 3 Man Game Losses 3 Man GWL% Overall Rank 1 9 Oded Kalir 14 10 58.33% 66 59 52.80% 14 2 12 Mike Brown 20 16 55.56% 101 96 51.27% 16 3 8 Marty Salata 13 20 39.39% 72 89 44.72% 23 4 11 Kock Yee Law 13 23 36.11% 79 105 42.93% 26

<colgroup><col span="2"><col><col><col span="7"></colgroup><tbody>
</tbody>

Thanks so much to anyone who can help with this!

Cheers,

Chris

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Replies
2
Views
412
Replies
4
Views
175
Replies
7
Views
115
Replies
8
Views
123
Replies
5
Views
275

1,203,524
Messages
6,055,905
Members
444,832
Latest member
bgunnett8

### 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.

### Which adblocker are you using?

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

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