How to add values of same date and same company

Hi All,

here I am attaching sample of my doubt.
I have to sum the values of same company and same date. can anyone help me with this issue.
For example in above sample i 123.xlsx (2.0 MB) have to filter the LIABILITY_COMPANY_GROUP column with one company and check DEPOSIT_DATE column if same date repeated many times then i have to sum up the values of LIABILITY_TAXABLE column values for those same date.

Hi @ryava_santhoshi - Please find attached the workflow as you requested. Try it, if works for your then mark this as a Solution to close the raised query.


MatchExcelDT.xaml (16.3 KB)

1 Like

Hi @ryava_santhoshi please check below workflow (627.0 KB)



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