cytochrome
New Member
- Joined
- Feb 8, 2017
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hi there,
I have a spreadsheet looked like below.
I dont know if VBA is better or using existing functions in Excel. But im looking to total the Net and Gross column if CODE, Account, Paydate, Currency are the same. So should look something like below. The new table should be on another sheet. Any help is greatly appreaciated.
I have a spreadsheet looked like below.
CODE | Account | Paydate | Net | Gross | Currency | |
123 | ABC | 20221216 | 1 | | 5 | USD |
360206 | DEF | 20221217 | 2 | | 10 | CAD |
123 | ABC | 20221216 | 10 | | 15 | USD |
360206 | GHI | 20221216 | 20 | | 20 | USD |
I dont know if VBA is better or using existing functions in Excel. But im looking to total the Net and Gross column if CODE, Account, Paydate, Currency are the same. So should look something like below. The new table should be on another sheet. Any help is greatly appreaciated.
CODE | Account | Paydate | Net | Gross | Currency | |
123 | ABC | 20221216 | 11 | | 20 | USD |
360206 | DEF | 20221217 | 2 | | 10 | CAD |
360206 | GHI | 20221216 | 20 | | 20 | USD |
| | | | |