Attached I have a version of the excel sheet that i need help with i need help finding a formula that can separate the most current month with a qty that is not 0 and have it separate the days and the amount based on those days and put it in the chart I am using excel 2016
Thanks
