Thread
:
Need help on which function to use.
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Need help on which function to use.
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett