Excel manipulation with filters

[Abhilash_K]

Book1.xlsx (9.4 KB)
sheet 1 will be the input , sheet 2 will be the expected output can someone help me how this can be achieved. In sheet 2 i should get only top 3

[THIRU_NANI (NaNi)]

Hi!

Have a view on this thread, You can find the xaml here

Excel Sum and deletion of duplicates

Hi, Please follow the below steps Excel Application scope with read range to read the excel Assign activity to assign dtTemp.Select(“ClientID= ‘yourVariable’”) to arrayofDaraRow variable check if count is greater than 1 sum the expense column using the given code dtTemp.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(1).ToString.Trim) ).ToString here I have converted the input to double format, you can use integer format if there is no decimals present and I have stored in a string variable. …

Regards,
NaNi

[Sanjit_Pal]

Hey @Abhilash_K,

Please refer the attached xaml.
PivotLinq.xaml (6.4 KB)

Thanks,
Sanjit