Need formula for this

[Mike911]

Can someone help me please with this in Excel 2010:

In the example of the attached picture:

Example with yellow cells: numbers in A1 and B1 to be detected on the columns E, F, I, J (cells A1 and B1 are always side by side in this way), then these two numbers to be displayed in the cell M3 plus the maximal of the numbers from the cells: C1, G2 and K4 (neighboring cells). The final text (cell M3) must look exactly like in the picture.

[Snuggles]

Hi Mike,
I would do this in two steps -- using three working columns.
In O, P, and Q, you would extract the yellow values of 80, 23, and 90 using a Sumifs function:
So, for Column O, the Sumifs would be: = Sumifs(C:C,A:A,A1,B:B,B1)
Do a similar thing, but change the formula slightly for columns P and Q as appropriate for the other columns.
In Column M, the formula would then need to be: =A1&";"&B1&";"&MAX(O1:Q1)
Someone may have this in one step.
This will should at least give you a patch until something more spiffy is posted.
Regards,
Snuggles

[jeffreybrown]

Hello Mike911 & Welcome to the Forum,

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...
• Also, please see Forum Rule #8 about cross posting and adjust accordingly...

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)