Find duplicate

[Yogita_Gaikwad]

i have one excel find the duplicate record from this and code is not stop even excel is empty

[Shikhar_Tandon]

Hi @Yogita_Gaikwad ,

Can you please elaborate your problem.

Thanks

[Yogita_Gaikwad]

Transaction_ Number | Transaction_Reference

1234 | Yogita
5678 | Minal
9101 | Nikhil
1122 | Akshay
1345 | Minal

above are the two excel column find the duplicate from Transaction_Reference column and want output below

Transaction_ Number	Transaction_Reference

                5678       |  Minal 
                1345       |  Minal

and also if excel is empty code still running

[Ayman_Alabsi1 (Ayman Alabsi)]

Hi @Yogita_Gaikwad

you can try this solution

Sequence.xaml (7.5 KB)

[Yogita_Gaikwad]

i only get Transaction reference column i also want Transaction Number of duplicate values

[Ayman_Alabsi1 (Ayman Alabsi)]

check the output columns in the filter data table, it could be there mistake in the column name.