identifying the max value across columns

Question

Hi there

I am analyzing survey data and the respondents were asked to allocate 100 points across 7 attributes. The way the data is displayed, is that each attribute is a separate row, with the respondents' scores for each attribute in separate columns:

IDQB2R1QB2R2QB2R3QB2R4QB2R5QB2R6QB2R7QB2R97QB2RSCTNEW_COLUMN010202001040100100QB2R6025510203020100100QB2R50310010201010400100QB2R7

I want to define a new column that returns the column name of the column with the highest score across all of the columns (see example "NEW_COLUMN" above). Is there a way to do this?

If a participant has entered the same score for the multiple top columns, then I just want the formula to return one column name (doesn't matter which one).

Please help!

CharlieS · Accepted Answer

I have attached one possible solution to your problem. I transposed your data, sorted, and took the first record name to append to the original data.

john_miller9 · Accepted Answer

The attached workflow seems to do the trick

tom_montpool · Accepted Answer

Rather than transposing your entire dataset, I took a bit of a different approach with a really neat formula function.