You’re offline. This is a read only version of the page.
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?
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (