Need help with which function to use.

Col A is labeled addresses in cell A1.
Col B is labeled Team 1 in cell B1
Col C is labeled Team 2 in cell C1
Team 3 in cell D1 etc. 12 teams

Cells A2 thru A50 contain e-mail addresses of players in the teams.
Cols B, C, D etc contain names for each player corresponding to their
e-mail address in Col A. Tom might be in cell B2 and Bill might be in B4,
Fred in B 27. Sam is in C6 and Tom is in C 9 etc.

How can I sort and group the players addresses from each team farther down
in Col A? Example, stating in cell A 55, I list addresses from players in
Col B, so in A55 would be Toms address and in A56 would be Bills address
etc. Farther on down Col A, I would list addresses from Col C etc, then
from Col C etc.







--
remej

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"remej01" wrote in message
...
Need help with which function to use.

Col A is labeled addresses in cell A1.
Col B is labeled Team 1 in cell B1
Col C is labeled Team 2 in cell C1
Team 3 in cell D1 etc. 12 teams

Cells A2 thru A50 contain e-mail addresses of players in the teams.
Cols B, C, D etc contain names for each player corresponding to their
e-mail address in Col A. Tom might be in cell B2 and Bill might be in
B4,
Fred in B 27. Sam is in C6 and Tom is in C 9 etc.

How can I sort and group the players addresses from each team farther down
in Col A? Example, stating in cell A 55, I list addresses from players in
Col B, so in A55 would be Toms address and in A56 would be Bills address
etc. Farther on down Col A, I would list addresses from Col C etc, then
from Col C etc.







--
remej