Hi
Can some excel guru help in using simple method to achieve running total base on column values ( the three col is the desire result)
Thank you
Can some excel guru help in using simple method to achieve running total base on column values ( the three col is the desire result)
Thank you
| Field | QTY | Running Total by Field Value |
| D001 | 2 | 2 |
| D001 | 4 | 6 |
| D001 | 89 | 95 |
| D002 | 54 | 54 |
| D002 | 4 | 58 |
| T003 | 6 | 6 |
| T003 | 11 | 17 |
| T003 | 67 | 84 |
| Z001 | 61 | 61 |
| Z002 | 12 | 12 |
| Z003 | 6 | 6 |
| Z004 | 6 | 6 |
| Z004 | 2 | 8 |
| Z004 | 5 | 13 |
| Z005 | 4 | 4 |