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:

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