Return MAX (or LARGE) for each 2D array's row with only ONE "spill" formula

Supposed I have the following table highlighted in light grey below (2D array "$A$1:$O$15")...

To extract the largest amount from each row down column Q is indeed a simple task using the MAX function (LARGE would also do the job...).

2D Spilled MAX for Each Row.png

However, in real life my table is dynamic... so its number of rows and columns may increase at any moment's notice - and I can't afford to copy down the basic/static formula every time that happens.

So, what I really need is a "spill" type formula, on the above case in cell "Q1", that returns me the largest amount for each row down the column, and that allows the answer span to grow and shrink accordingly...

And as usual, please no macros/VBA, and on this case the use of a helper column on a named table also would not help me since this is something I need to embed inside another formula.

Thanks in advance for any help on this!

Leonardo

P.S.:
I've also posted the same question under the Microsoft Community board.
https://answers.microsoft.com/en-us/...e-976bcd966ba6

How about

Formula:

Please Login or Register  to view this content.

Thanks a bunch! That sure did the trick!

You're welcome & thanks for the feedback.

@wk9128 That is getting the max value of the column, not the row.