How to identify duplicates in excel column?

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.
Capture

@Venkatesh_Chowdary, this one, An Existing Solution

Regards,
Dom :slight_smile:

1 Like

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,

1 Like