How to avoid duplicate and add remarks

[Gokul_Murali]

Hello guys i have an excel given below

Here the name “RAJU” Duplicated 2 times and in status it should show “duplicate”.

[pravallikapaluri]

Hi @Gokul_Murali

Copy Excel Table To Email.zip (216.6 KB)

[Gokul_Murali]

The doc is showing invalid is it possible it get the expression used in the dict variable and the expression used in the if condition under for each.

[pravallikapaluri]

@Gokul_Murali

dict=New Dictionary(Of String, Boolean)

IF
Not dict.ContainsKey(CurrentRow("Name").ToString)

[pravallikapaluri]

@Gokul_Murali

Did you got solution?

[Gokul_Murali]

I got the solution, thank you so much @pravallikapaluri