Filter rows based on same values in one of the column

Hi, I have an excel, need to filter the data based on the same date values in one of the columns.

Below attached is the sample:

Here I need to filter out the data and get the sum of data on the base of the same date and account number in the first column As of the date and second column Account number.
Need the output as:




Give a try on (quick Prototype handling Date on String Base):
dtResult =dtData.Clone

(From d in dtData As Enumerable
Group d by k1=d(0).toString.Substring(0,11), k2=d(1).toString.Trim into grp=Group
Let s = grp.Sum(Function (x) CDbl(x(2).toString.Trim))
Let ra = new Object(){k1,k2,s,grp.First()(3)}
Select dtResult.Rows.Add(ra)).CopyToDataTable

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.