Return the table column # containing the maximum value in a row

In my table, T, columns 14 through 27 contain numeric data. I want to find the maximum value in each row and then return the associated column # or column title.

I can get the value with:

for i=1:size(T)
   maximum = max(T{i,14:27});
end

But I'm struggling to get the associated column # or title.

Answer 1

[Peter Perkins]

I think you want something like this:

[maxVals,maxLocs] = max(T{:,14:27},[],2)

In other words, for the contents of the 14th-27th variables in T, find the maximum value and the variable in which it occurred. If you want the var names, follow up with this:

maxVarNames = T.Properties.VariableNames(maxLocs)