I have thirty days worth of customer demand for parts. I would like excel to find the greatest sum during any 7 day period and give me that value in a cell at the end of a row of data that includes blank cells and date gaps.
I have thirty days worth of customer demand for parts. I would like excel to find the greatest sum during any 7 day period and give me that value in a cell at the end of a row of data that includes blank cells and date gaps.
Last edited by Sebastion; 05-12-2011 at 07:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks