December 29, 2022
Right now i have a excel table from which i use sumif formula to extract numbers based on date and few othe criteria to filter values by date.
I also have three sets, which has a upper limit of 70000, so each time a set reaches max, the next set will start adding and so.
Each time set gets to max limit, it needs to deplete based on daily value and so on.
As each set follows a loop of build and deplete, i am currently working manually each week to output graphs to show the build and deplete values in graph format for each set.
Any help to automate this graph is much appreciated.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013