Hi all
I want column F to summarise all text data detailed in columns A, B, C, and D, but only showing one result no matter how many times the same entry occurs in A-D.
EXAMPLE:
A B C D E F
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Column F shows data from all 4 columns without repetition, even though they are not in the same order.
Is this possible?
I want column F to summarise all text data detailed in columns A, B, C, and D, but only showing one result no matter how many times the same entry occurs in A-D.
EXAMPLE:
A B C D E F
Mr A | Mr R | Mr Z | Mr L | Mr A | |
Mr B | Mr Z | Mr Q | Mr B | ||
Mr R | Mr A | Mr A | Mr R | ||
Mr Z | Mr Q | Mr Z | |||
Mr L | Mr Q | ||||
Mr L |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Column F shows data from all 4 columns without repetition, even though they are not in the same order.
Is this possible?