Finding MAX interval from 2 groups of data

[Grimace]

Good afternoon all,

I am trying to find the max time interval when 2 different tables are added together, and what time that was. Preferably without having a totally seperate table to add into the sheet. I could do it this way but makes it messy for me.

On the attached sheet, I need to find when the sum of group 1 and group 2 in the same time interval = the max for the day, and return the value and the time at the bottom.

Any assistance would be really appreciated

Thanks
Darren

[zbor]

You mean like this?

In C61
=INDEX($A$32:$A$57, MATCH(MAX(C2:C27+C32:C57), INDEX(C2:C27+C32:C57, 0), 0))

comfrimed with ctrl+shift+enter (not just enter)

For SUM use: =MAX(C2:C27+C32:C57)
comfrimed with ctrl+shift+enter

[zbor]

If you use it in this way you can in C61 have =INDEX($A$32:$A$57, MATCH(C62, INDEX(C2:C27+C32:C57, 0), 0)) referencing to C62 and then you can use normal enter.

[Grimace]

Awesome zbor .... I can claim to have tried the Sum forumla (most basic of them all) but had forgotten to register it with Shift+Ctrl+Enter.

Do you have a reference point where I can learn some more about when to use this technique (ie what it is that is different, and what to look out for). I have had it a few times in responses from Forum topics, and still dont have a grip on when I should be using it.

Thanks so much again

[zbor]

It's something called Array.
You use them when you don't work with cingle cells but with arrays..

You will recognise those formula's by {=formula} brackets around formula..
Those brackets can not be entered manualy, you must get them by pressing ctrl+shift+enter.

Try to read somewhere, like here... And then come back with more questions
It takes some time to ge used to it...

Take for example this simple workbook where you need to sum products of the rows...

Of course, you can use SUMPRODUCT formula (like in B7) but you can also see SUM solution for that.