You’re offline. This is a read only version of the page.
68
There is an online excel table as below structure:
| InvNo | ProID | Amt |
| 001 | P01 | 100 |
| 001 | P02 | 200 |
| 001 | P02 | 100 |
| 002 | P02 | 100 |
| 002 | P03 | 150 |
I want to add row with same InvNo & same ProID and sum the Amt as below structure:
| InvNo | ProID | Amt |
| 001 | P01 | 100 |
Total | 100 | |
| ||
| 001 | P02 | 200 |
| 001 | P02 | 100 |
Total | 300 | |
| ||
| 002 | P02 | 100 |
Total | 100 | |
| ||
| 002 | P03 | 150 |
Total | 150 |
Since Office Scripts is not available for me, is it able to achieve this with power automate without premium access?
Share
Report
All responses (
Answers (
