Excel - Auto-populate a row of cells depending on multiple criterias [closed]
up vote
0
down vote
favorite
I have a sheet with a list of names, teams, and their codes and the format for each column header is:
- NAME > TEAM > CODE
I want to be able to populate a row of cells with each of their codes taking one cell when I enter their team in a column.
For example: If CELL A1 contains "TEAM A", everyone from team A will populate RANGE B2-B6 without any duplicates.
Any ideas?
microsoft-excel worksheet-function microsoft-excel-2010
asked Nov 17 at 4:11
user964587
1
closed as unclear what you're asking by Scott, fixer1234, Toto, bertieb, PeterH Nov 19 at 11:31
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
0
down vote
favorite
I have a sheet with a list of names, teams, and their codes and the format for each column header is:
- NAME > TEAM > CODE
I want to be able to populate a row of cells with each of their codes taking one cell when I enter their team in a column.
For example: If CELL A1 contains "TEAM A", everyone from team A will populate RANGE B2-B6 without any duplicates.
Any ideas?
microsoft-excel worksheet-function microsoft-excel-2010
asked Nov 17 at 4:11
user964587
1
closed as unclear what you're asking by Scott, fixer1234, Toto, bertieb, PeterH Nov 19 at 11:31
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a sheet with a list of names, teams, and their codes and the format for each column header is:
- NAME > TEAM > CODE
I want to be able to populate a row of cells with each of their codes taking one cell when I enter their team in a column.
For example: If CELL A1 contains "TEAM A", everyone from team A will populate RANGE B2-B6 without any duplicates.
Any ideas?
microsoft-excel worksheet-function microsoft-excel-2010
asked Nov 17 at 4:11
user964587
1
I have a sheet with a list of names, teams, and their codes and the format for each column header is:
- NAME > TEAM > CODE
I want to be able to populate a row of cells with each of their codes taking one cell when I enter their team in a column.
For example: If CELL A1 contains "TEAM A", everyone from team A will populate RANGE B2-B6 without any duplicates.
Any ideas?
microsoft-excel worksheet-function microsoft-excel-2010
microsoft-excel worksheet-function microsoft-excel-2010
asked Nov 17 at 4:11
user964587
1
asked Nov 17 at 4:11
user964587
1
asked Nov 17 at 4:11
user964587
1
asked Nov 17 at 4:11
user964587
1
asked Nov 17 at 4:11
user964587
1
1
closed as unclear what you're asking by Scott, fixer1234, Toto, bertieb, PeterH Nov 19 at 11:31
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by Scott, fixer1234, Toto, bertieb, PeterH Nov 19 at 11:31
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
