How to sum the amount of duplicate ID's

[bhanu.priya2 (Bhanu Priya)]

Hi All,

Kindly find the below input sheet,

and i want output as same as below

It should check the whether the ID and corresponding wage type is same then i need to sum the amount of corresponding ID and wage type, please help me

[Yoichi]

Hi,

Can you try the following?

deResult = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Emp-Id").ToString,r("Wage type").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.Key.Item1,g.Sum(Function(r) Int32.Parse(r("Amount").ToString)).ToString,g.Key.Item2},False)).CopyToDataTable()

Sample20220131-2.zip (4.6 KB)

Regards,

[Palaniyappan (Palaniyappan P)]

Hi

Have a view on this thread on similar note and suggestions

Find sum of values by grouping in a Data Table

Hello All, I have a Data Table as below: [Capture] What I would like to find out is the sum of all Invoice Values corresponding to a Client Name. So the output should be like below: <ClientName 1>:Total Invoice Value <ClientName 2>:Total Invoice Value … … and so on. How shall I get this done. Kindly help. Regards.

Cheers @bhanu.priya2

[Gokul001 (Gokul Balaji)]

Hi @bhanu.priya2

Try the below expression for removing Duplicate values and copy the unique values in the DT

(From p in DT.Select() where( From q in DT.Select() where q(“Emp-id”).Equals(p(“Emp-id”)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

Regards
Gokul

[gurramramu.121]

Can You Explain me how this work

xlWorkSheet1.Range(SourceCellValue).Copy()
xlWorkSheet6.Range(SourceCellValue).PasteSpecial(XlPasteType.xlPasteValues, XlPasteSpecialOperation.xlPasteSpecialOperationNone, False, False)

[bhanu.priya2 (Bhanu Priya)]

Thank you so much Yochi, it is working super fine

[bhanu.priya2 (Bhanu Priya)]

Thanks for the reply checked your solution also and it is working fine

[bhanu.priya2 (Bhanu Priya)]

Thank you for your reply

[bhanu.priya2 (Bhanu Priya)]

Thank you palaniyappan, i got the solution