Hi, I've been trying to find mutliple hits matching one criterion (column E) so as to produce the following results in column F:
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
In column A, I have the codes and in column B there are the corresponding names.
I need to have the codes in column E and in column F to have all the names corresponding to each code. As you can see, there are more than one instances in some codes.
Do you think this is possible? Of course index/match in the classic way I'm using it, produces only the first name for each code.
I've been trying for quite some time to find something to solve it, but I have not been successful. So, I'd appreciate your thoughts on this!!!
Thanks in advance for any advice.
A | B | C | D | E | F |
TYPE | NAME | CRITERIA | RETURN VALUE | ||
1.0.1 | JOHN | 1.0 | |||
0 | 1.0.1 | JOHN | |||
1.0.2 | MARY | 1.0.2 | MARY | ||
0 | 2.0 | ||||
2.0.1 | GEORGE | 2.0.1 | GEORGE | ||
0 | 2.0.2 | ADAM | |||
2.0.2 | ADAM | 2.0.2 | JOHN | ||
2.0.2 | JOHN | 2.1 | |||
0 | 2.1.1 | HELEN | |||
2.1.1 | HELEN | 2.1.1 | MARY | ||
2.1.1 | MARY | 2.1.1 | ANNE | ||
2.1.1 | ANNE | 2.1.1 | JIM | ||
2.1.1 | JIM | 2.2 | |||
0 | 2.2.1 | MARY | |||
2.2.1 | MARY | 2.2.1 | CHARLES | ||
2.2.1 | CHARLES | 2.2.1 | ERIC | ||
2.2.1 | ERIC | 2.2.1 | JOHN | ||
2.2.1 | JOHN |
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
In column A, I have the codes and in column B there are the corresponding names.
I need to have the codes in column E and in column F to have all the names corresponding to each code. As you can see, there are more than one instances in some codes.
Do you think this is possible? Of course index/match in the classic way I'm using it, produces only the first name for each code.
I've been trying for quite some time to find something to solve it, but I have not been successful. So, I'd appreciate your thoughts on this!!!
Thanks in advance for any advice.