ExcelMercy
Board Regular
- Joined
- Aug 11, 2014
- Messages
- 151
Hello all,
I'm trying to merge two columns with two different columns (different sizes) and then have another column tell whether the data appeared in both or just one.
Example Data:
<tbody>
</tbody>
Example Output:
<tbody>
</tbody>
Any help would be greatly appreciated!
I'm trying to merge two columns with two different columns (different sizes) and then have another column tell whether the data appeared in both or just one.
Example Data:
Num_1 | Name_1 | Num_2 | Name_2 |
A111 | Jim | A111 | Jim |
A123 | John | A111 | Cory |
B134 | Susan | A124 | Marcus |
B134 | Lori | B121 | Donald |
C786 | Billy | B134 | Mark |
D555 | John | B134 | Lori |
D555 | Mark | C786 | Billy |
F121 | Kim | C786 | Donny |
F124 | Bonnie | D124 | Thomas |
F475 | Brandon | D124 | Austin |
G857 | Bill | D124 | Stacy |
D555 | John | ||
D558 | Justin | ||
F121 | Kim | ||
F124 | Bonnie | ||
F475 | Brandon | ||
G857 | Bill |
<tbody>
</tbody>
Example Output:
Match_Num | Match_Name | MATCH RESULTS |
A111 | Jim | In Both |
A111 | Cory | In "2" Only |
A124 | Marcus | In "2" Only |
B121 | Donald | In "2" Only |
B134 | Mark | In "2" Only |
B134 | Lori | In Both |
C786 | Billy | In Both |
C786 | Donny | In "2" Only |
D124 | Thomas | In "2" Only |
D124 | Austin | In "2" Only |
D124 | Stacy | In "2" Only |
D555 | John | In Both |
D558 | Justin | In "2" Only |
F121 | Kim | In Both |
F124 | Bonnie | In Both |
F475 | Brandon | In Both |
G857 | Bill | In Both |
A123 | John | In "1" Only |
B134 | Susan | In "1" Only |
D555 | Mark | In "1" Only |
<tbody>
</tbody>
Any help would be greatly appreciated!
Last edited: