jamescurtis29
New Member
- Joined
- Jan 9, 2019
- Messages
- 3
Hello Excel superior beings, I bow to your wisdom and knowledge.
Apologies for reposting this question, the last post had such poor layout! I think I've fixed it now and you can see the tables below.
I know this must be possible but I cannot think of how to do it and have used this forum in the past to find information but have not been able to find this question asked previously.
I have a list of groups with group ids and members of each group representing subgroups. It looks a little like this:
<thead>
</thead> <tbody>
</tbody>
I want to find the most common pairings of subgroups. So in the list above a+b appear in 1 groups, a+c appear in 1 groups, b+c appear in 1 group, c+d appear in 2 groups and b+e appears in 1 group. But I cannot think of how to achieve it.
I think it would end with a table that looks like:
<thead>
</thead> <tbody>
</tbody>
Any ideas? Something to do with countifs and pivot tables?
Thank you in advance for your help. If you alternatively can think of the answer to this from a previous post and could share that with me, that would also be very welcome!
Apologies for reposting this question, the last post had such poor layout! I think I've fixed it now and you can see the tables below.
I know this must be possible but I cannot think of how to do it and have used this forum in the past to find information but have not been able to find this question asked previously.
I have a list of groups with group ids and members of each group representing subgroups. It looks a little like this:
Group | Sub-group | |
---|---|---|
1 | a | |
1 | b | |
1 | c | |
2 | c | |
2 | d | |
3 | c | |
3 | d | |
4 | b | |
4 | e |
<thead>
</thead> <tbody>
</tbody>
I want to find the most common pairings of subgroups. So in the list above a+b appear in 1 groups, a+c appear in 1 groups, b+c appear in 1 group, c+d appear in 2 groups and b+e appears in 1 group. But I cannot think of how to achieve it.
I think it would end with a table that looks like:
Sub-group | Sub-group | number of groups |
---|---|---|
c | d | 2 |
a | c | 1 |
b | c | 1 |
a | b | 1 |
b | e | 1 |
<thead>
</thead> <tbody>
</tbody>
Any ideas? Something to do with countifs and pivot tables?
Thank you in advance for your help. If you alternatively can think of the answer to this from a previous post and could share that with me, that would also be very welcome!