Count the Total number of values in Excel Column

[Yugal_Raju]

Hello all,

I would like to know how get the total count of Row2 ( Completed / Denied ) Based on the condition of Row1

Example : For Suzuki - Completed count - 2 and Denied count 2 and so on.

Attached Excel for reference,

Thanking you,

dummy.xlsx (9.1 KB)

[Gokul001 (Gokul Balaji)]

HI @Yugal_Raju

How about this expression

(From d In DtBuild.AsEnumerable()
Group d By k=d("Row 1").toString.Trim, k1=d("Row 2").toString.Trim Into grp = Group
Let coun = grp.count
Let ra = New Object(){k,k1,coun}
Select r = DtClone.Rows.Add(ra)).CopyToDataTable()

Check out the XAML file

UpdateDtUsingLINQ.xaml (8.9 KB)

Regards
Gokul

[Yugal_Raju]

i Would like to get the count individually as I need to enter the count in separate spreadsheet
Suzuki Spreadsheet - Completed and denied count
Honda Spreadsheet - completed and denied count etc

[Gokul001 (Gokul Balaji)]

Can you share the sample output @Yugal_Raju

[Gokul001 (Gokul Balaji)]

Hi @Yugal_Raju

Check out the XAML file

UpdateDtUsingLINQ.xaml (12.6 KB)

It will create the folder like this

Regards
Gokul