Wants too count the duplicate values in excel file

[Manjuts90]

@Shubham4323 Please check below link.

How to count the presence of duplicate values in the excel file and pass that count value in another excel file?

You need to understand the For Each loops. They are looking at each row, but you tell it which column to cycle through. row.Item(“Name”).ToString So just update the column name to that which you are looking to count duplicates in. As for the comparing that against another column for duplicates, you can just update the CheckDup variable in a similar way. I don’t know what you mean by the select query question. If you are looking to use the information output, e.g “Name: Sandeep Count: 3”, the…