Hi Everyone, I would like to identify the number of duplicates in the below Column Name “ID” and their row indexes also. With that number I need to iterate the values. ID 10001 10001 10001 10001 10001 10001 10002 10002 10002 10003 10003 10003 10003 10003 10004 10004 10004 Thanks …

Identify the number of duplicates items in a column and their row index

ppr (Peter Preuss) August 30, 2019, 3:18pm 12

@mattelstonschwartz
Give a try to LINQ with GroupBy and the benefit from one of the aggregating functions

DataTable Manipulation For below table

Topic		Replies	Views
Identify the Duplicates and sum the value Help	7	4601	September 14, 2019
Duplicate Values Count increment - HELP Studio datatable , excel , selector , uiautomation , studio , data_scraping , string , question	12	1802	April 2, 2021
Retrieve duplicated values from excel rows Help	7	731	July 5, 2020
Counting duplicate values in columns using counter Studio datatable , excel , activities , question	10	1679	October 15, 2020
How to find duplicate values in excel (count the row if yes will remove those) Studio	4	201	November 3, 2023