Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1474261%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1474261%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20in%20the%20water%20%2F%20wastewater%20industry%20and%20we%20have%20a%20program%20that%20we%20use%20to%20pull%20numbers%20off%20of%20for%20the%20wastewater%20portion%20to%20calculate%20a%20two%20hour%20peak%20flow.%20The%20program%20pulls%20the%20daily%20flows%20for%20the%20month%20in%2015%20minute%20increments.%20I%20need%20to%20find%20the%20highest%20combined%20flow%20for%20two%20hours%20(9%20cells).%20Is%20there%20a%20formula%20that%20can%20do%20this%3F%20Normally%20I%20have%20to%20scroll%20through%20the%20whole%20month%20and%20find%20the%20highest.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1474261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1474640%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1474640%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703564%22%20target%3D%22_blank%22%3E%40Kayla_Marley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understand%20this%20properly%2C%20you%20would%20first%20need%20to%20populate%20the%20flow%20for%20the%20combined%20past%20two%20hours%20for%20each%20given%20time%2C%20then%20return%20the%20highest%20number.%20See%20the%20attached%20spreadsheet%20if%20it%20helps.%20(I%20input%20some%20random%20number%20in%20there).%3C%2FP%3E%3CP%3EColumn%20A%20is%20a%20date%20and%20time%2C%20incremented%20every%2015%20minutes.%3C%2FP%3E%3CP%3EB%20is%20the%20flow%20returned%20by%20your%20program.%3C%2FP%3E%3CP%3EC%20is%20the%20combined%202%20hours%20flow.%3C%2FP%3E%3CP%3EE%20is%20a%20simple%20%3DMAX(C%3AC)%20which%20is%20what%20finds%20your%20highest%20number%20in%20column%20C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20that%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I work in the water / wastewater industry and we have a program that we use to pull numbers off of for the wastewater portion to calculate a two hour peak flow. The program pulls the daily flows for the month in 15 minute increments. I need to find the highest combined flow for two hours (9 cells). Is there a formula that can do this? Normally I have to scroll through the whole month and find the highest.

1 Reply
Highlighted

Hi @Kayla_Marley 

If I understand this properly, you would first need to populate the flow for the combined past two hours for each given time, then return the highest number. See the attached spreadsheet if it helps. (I input some random number in there).

Column A is a date and time, incremented every 15 minutes.

B is the flow returned by your program.

C is the combined 2 hours flow.

E is a simple =MAX(C:C) which is what finds your highest number in column C 

 

Does that help?