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.

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.

In that case, there is 2 way.

Option1.

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

Option2.

- 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,

1 Like