Record duplicate cells in Excel

Good afternoon people!

I’m removing duplicate cells from Excel, I can already make uipath do this process, but I want to get the record of which duplicates were removed, and this part that I’m not able to do in uipath.

Hi

Have a view on this thread

Cheers @Luan_Carvalho_Da_Conceica

Guys, and so was the end result;
1 Assign declaring datatable read range =
(From p in output.Select() where (From q in output.Select() where string.Join(",", q.ItemArray) .Equals (string.Join(",", p.ItemArray)) Select q ) .ToArray.Count> 1 Select p) .ToArray.CopyToDataTable ()

2 Remove duplicate rows by taking Assign data table declaring read range data table.

3 Output data table getting data table Remove duplicate rows.

4 Append Line taking data table output data table to store in notepad.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.