How to identify duplicates in excel column?

[Venkatesh_Chowdary (0099)]

need to find the duplicate values in excel column and the corresponding values to be added and write in another column as shown below.

thank you.

[Dominic]

@Venkatesh_Chowdary, this one, An Existing Solution

How do I group by one column in the datatable and take the sum?

@jamnanin I will suggest you one more way try like this. Let us take your excel stored in a datatable dta First group the datatable based on ID by using below Query and assign it to dt1 dt1=(From p In dta.Select() Group p by ID=p.Item(“ID”).ToString Into Group Select Group(0)).ToArray.CopyToDataTable() Now take only two columns by using below query dt1=dt1.DefaultView.ToTable(False,“ID”,“Name”) Now Add one datacolumn to dt1 by using add datacolumn activity and give name Amount to that c…

Regards,
Dom

[Jumbo (Jumbo Suzuki)]

In that case, there is 2 way.

Option1.

1. Get Column A and B as Data table(dtbA)
2. Loop at dtbA to row and assigin dtbB = dtb.select(ColumnB = row value)
3. if dtbB has more than 2 line, that duplicate.

Option2.

1. Add countif excel formula in column C and if it is more than 2, then it duplicate.

I recommend option 2 if you can add new column.

Rgds,
J,