Hello,
I would like to find and report the records where a value Column 3 repeats in column 5. se below:
Column1 | Column2 | Column3 | Column4 | Column5 |
1 | 43 | 1543 | 1543 | 1422 |
2 | 45 | 8964 | 52 | 1543 |
3 | 78 | 6835 | 6835 | 4443 |
4 | 96 | 6824 | 45 | 3488 |
5 | 26 | 12322 | 12322 | 9008 |
6 | 83 | 3488 | 45 | 4411 |
output:
Column1 | Column2 | Column3 | Column4 | Column5 |
1 | 43 | 1543 | 1543 | 1422 |
2 | 45 | 8964 | 52 | 1543 |
4 | 96 | 6824 | 45 | 3488 |
6 | 83 | 3488 | 45 | 4411 |
Is there anyway to do this?
Cheers,
Tony
Solved! Go to Solution.
Hi @TonyMu ,
A quite unorthodox way but it turned out it works.
I have also tested it slightly by adding different values to Columns 3 and 5 and seemed to be doing alright, the results looked correct.
Let me know if that works for you.
Cheers,
Angelos