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
