I am in the need of some help. What I have is a simple excel data set. 2 columns, Column A is Time of day in 24 hrs @ 15 min intervals, (A1:A96). Column B contains whole numbers, (4 digits with comma) that are entered at every corresponding 15 min interval in Column A. I am needing the Max of Column B, which is obviously easy. My issue is I am needing the average, starting from the Cell containing the Max and the next 7 consecutive cells. It doesn't matter to me if the formula needs to correspond with the Max, or if using the Time the Max is found and averaging the next 7-15 min cell data including the Max.
For hopefully some better insight:
What is happening is every 15 minutes, a reading is taken from a flow meter automatically via a program called XLR Reporter. The State Regulatory Agency over this program requires a 2 hour peak average for every 24 hrs, starting from the Max reading which is completely random, which totals 8 - 15 minute readings.
Any help on this is greatly appreciated!
For hopefully some better insight:
What is happening is every 15 minutes, a reading is taken from a flow meter automatically via a program called XLR Reporter. The State Regulatory Agency over this program requires a 2 hour peak average for every 24 hrs, starting from the Max reading which is completely random, which totals 8 - 15 minute readings.
Any help on this is greatly appreciated!
