How to identify duplicates in excel column?

datatable
excel
activities

#1

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


#2

@Venkatesh_Chowdary, this one, An Existing Solution

Regards,
Dom :slight_smile:


#3

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,