max value within a time range

Hello

I would like to find the max value "High" (Column C) within every range of Time 19:00 to 17:00 in a large data set

Then with the next range of 19:00 to 17:00

Then mark the High of the 7:00 Time and mark if that value is higher then the previous 19 to 17 Segment High

Thank You

Does your version support the MAXIFS() function? If so, I would do something like:

1) Add a helper column to combine date and time into a single value. In D2, enter =SUM(A2:B2) and copy/paste/fill down.
2) In my summary table, enter the 7 PM on each date. I chose J2 and entered 5/12/2019 19:00, in J3, entered 5/13/2019 19:00, then dragged to fill down as far as needed.
3) The max for each 7 PM to 5 PM period is then a simple MAXIFS() function. =MAXIFS($C$2:$C$1000,$D$2:$D$1000,">="&J2,$D$2:$D$1000,"<"&J3) entered into K2 and copied down.
4) Assuming I understand the next step, the value at 7 PM is a simple lookup function. =INDEX($C$2:$C$1000,MATCH(J2,$D$2:$D$1000,1)). In L2 and copied down.
5) Then you can compare the maximum from the previous time period with the value at 7 PM of the next time period with a simple boolean expression (entered into an IF() function, if desired). In M3, I can enter =IF(L3>K2,"larger","not") copy/paste/fill down.

Would a strategy like that work for you?

Since the moderators have directed you back here, is there something in my solution that you are having trouble implementing? Or something I misunderstood? Or do you simply prefer a VBA based solution since you tried posting in the VBA section?

yes I m thinking vba solution

or maybe not I will try your suggestion

Thank You

Boolean is an expression that results in a "true/false" result. In the example I gave =IF(L3>K2,"larger","not"), the L3>K2 is the boolean expression that will return TRUE if L3 is larger than K2, and FALSE if it is not. Then the IF() function makes a choice based on the boolean result.

Please amend your file to show EXPECTED answers... exactly as you want them... where you want them.

Which step is giving you trouble?

When I follow the steps I outlined, I get this.

When I started learning spreadsheets, this was one of the help files I most frequently referenced: https://support.microsoft.com/en-us/...rs=en-us&ad=us

Shorty I got your suggestion to work but the issue is 5/12/2019 1900 to 5/13/2019 1700 is one day

Shorty I sent an amended file I m wanting to copy these formulas down

Thanks for the sample file. That makes things clearer.

Delete ALL expected results.

Formula:

Please Login or Register  to view this content.

Put it wherever you want on that sheet! Just ensure there's room for the results to spill across and down. The only adjustment needed is to sub-formula A (the range)..

You're welcome.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

I have no idea what you are talking about. Add your expected answers to my LAST attachment.

I still have absolutely no idea what you are talking about.

WHAT do you expect to see?

WHERE doe you expect to see it?

SHOW me in a file... don't given me another explanation that (to me) makes no sense!!