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”
dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“columnWithDuplicate”)).Select(Function(g) g.First).CopyToDataTable