Find duplicates in a column using Excel activities


Another method to get unique values you can directly read the data into a datatable and then

uniquedt = Dt.Defaultview.ToTable(true,{"IDCol"})

If you want to make the specific one bold…

Initialize a list(L1)new list(of string) , Then loop through dt and then inside the loop you can use if condition to check if the list contains the currentrowitem …L1.any(function(x) currentrow("IDCol").Tostring.Contains(x))

In the else side use the below logic to make it bold(send ctrl+B)…and leave the then part blank