Duplicate entry in Excel

How to update Duplicate status in Excel if Date and amount similar to other transaction of same date and amount.

Have you tried the given activity https://docs.uipath.com/activities/lang-en/docs/excel-remove-duplicates-range already?

here we have option to remove the data but i am looking for status to update on specified cell “This is Duplicate transaction”

@Vasanthr Refer the attached Xaml file.

Sequence.xaml (16.7 KB)
test.xlsx (10.4 KB)

Happy coding :slight_smile:

dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“columnWithDuplicate”)).Select(Function(g) g.First).CopyToDataTable