I have two columns of data, one contains a unique identifier, the other contains another 4 digit key.
What I want to do is for the unique identifier when there is more than one 4 digit key that is associated to it, I would like to to display x. Marking both entries not just the first or second. For example:
<tbody>
</tbody>
Does anyone have any suggestions for how to best tackle this?
TIA
What I want to do is for the unique identifier when there is more than one 4 digit key that is associated to it, I would like to to display x. Marking both entries not just the first or second. For example:
4 digit Key | Unique Identifier | Duplicate |
PL01 | AB | |
BE01 | ABC | |
BE01 | ABCD | |
BE01 | ABCDE | x |
FR05 | ABCDE | x |
BE01 | ABCDEF | x |
GB30 | ABCDEF | x |
GB30 | ABCDEFG | |
PL01 | ABCDEFGH | |
GB30 | ABCDEFGHI | x |
PL01 | ABCDEFGHI | x |
<tbody>
</tbody>
Does anyone have any suggestions for how to best tackle this?
TIA