Share
Report
23Hi guys,
I have extracted a datatable from excel which has all the values that I need. My goal is to calculate the sum of all values present in Column H (Amount in local currency) and the sum of all the values present in Column I (Arrears after net due date), with respect to the names in Colum C (Name 1).
The names can be anywhere in the excel table.
Example Table:
| Customer | Name | Net due date | Amount in local currency | Arrears after net due date |
| 1000 | Name 1 | 2/4/2006 | 1000 | 10 |
| 1001 | Name 2 | 4/23/2010 | 500 | 5 |
| 1002 | Name 3 | 5/16/2015 | 2000 | 15 |
| 1000 | Name 1 | 2/10/2006 | 1000 | 10 |
| 1001 | Name 2 | 2/4/2006 | 500 | 5 |
| 1002 | Name 3 | 8/26/2013 | 2000 | 15 |
Required Output:
| Customer | Name | Net due date | Amount in local currency | Arrears after net due date |
| 1000 | Name 1 | 2000 | 20 | |
| 1001 | Name 2 | 1000 | 10 | |
| 1002 | Name 3 | 4000 | 30 |
@DuaneM_iTalent
Categories:
I have the same question (0)
All responses (
Answers (
