Find the row that has the maximum value across a number of columns

JNollett 

Seems I still had the workbook in memory on my laptop.  It also contains an implementation of one of Twifoo's formulas.  One thing I did when creating the table was to exclude the Name and Totals columns, leaving a blank column to separate them.  This allows me to use

VALUE(Table1[#Headers])

which grows dynamically with extra columns, rather than

VALUE(Table1[[#Headers],[1]:[9]])

which would need to be edited to include additional columns.

The SORTBY column is a new function, introduced last September, and gradually being rolled out as part of the Dynamic Array changes.

= @ SORTBY( Name, score, -1 )

sorts the 'Name' array by 'score' in descending order.  The '@' sign before the an array result truncates the result to a single value (otherwise I would get a sorted version of the entire list of names).

At present, you will have the new function if you are signed up to Office 365 insider (weekly updates); it is in the process of being rolled out to 'monthly' and 'semi-annual' may have some time to wait.

Twifoo 

I think the term

(Table1[[#Headers],[1]:[9]])^0

is redundant since the following terms will give the same result without it.