Excel Learner 77
New member
- Joined
- Aug 29, 2014
- Messages
- 13
- Reaction score
- 0
- Points
- 0
I have two columns in Workbook1 - "Issues" and "Regions":
I like to list all Issues according to Regions with their corresponding Issues in second Workbook or Excel File such as below:
Could you show me a formula to do this and how? Thanks.
Issues | Regions |
4455 | Atlantic |
2555 | Central |
7777 | Midwestern |
3333 | Central |
4444 | Central |
6333 | Midwestern |
I like to list all Issues according to Regions with their corresponding Issues in second Workbook or Excel File such as below:
Regions | Issues |
Atlantic | 4455 |
Central | 2555, 3333, and 4444 |
Midwestern | 7777 and 6333 |
Could you show me a formula to do this and how? Thanks.