R
remej01
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.
Col’s 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 Tom’s 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.
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.
Col’s 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 Tom’s 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.