How to write value in duplicate cell

[wsinten (KANZ)]

Hi everyone,

i want to write “duplicate” in column C when the data in column A is duplicated. what activity should i use? Thank You

[Gokul001 (Gokul Balaji)]

HI @wsinten

Check out the thread

Excel Automation - Check and Identify duplicate records/rows

Hello Everyone Happy Sunday! I have duplicate records/rows in my excel and I wanted to know or have an “identifier” for all the records that are duplicate. What I was thinking was to perform each row check but I don’t know how to code it and I don’t know if that’s the best approach. Anyone can share light on this please? Please see below for more information. Thanks Raw data (Filter: IF First Name, Last Name, Company, and Location have the same values) ID First Name Last Name Age Company …

Write duplicate in front of duplicate values in excel

Hi @Jeeru_venkat_Rao , You could also try with an alternate using Linq. Check the steps below : Assumed the Datatable is read using Read Range Activity, say DT. Also assuming that the Remarks Column is not present already in this data. Next, we clone the Input datatable DT and create the Output datatable, OutputDT where OutputDT is a variable of type Datatable. OutputDT = DT.Clone The above is done using an Assign Activity. Next, Add the Remarks Column to the Output Datatable using…

Regards
Gokul

[wsinten (KANZ)]

Hai @Gokul001

Oke. I will check your thread. Thank You

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @Gokul001, Thanks for sharing, it’s been very useful.

[wsinten (KANZ)]

hi @Gokul001,

Thank you for your help. this thread really helped me. and my problem is solved