Excel manipulation with filters

[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