809444_en-US

liliconcom

comparing data in rows and naming according to column names

Greetings, I have a data set for which I would like to have a column formula that considers several rows, and then returns a name to the new column according to the row data, specifically the highest value among the selected rows.   I would like the name returned to be the same name from those columns considered. 

 

Something like this, what would that formula be please?   (Thank you ahead of time for helping a JMP rookie.)

 

Content OrganizationData Blending and CleanupRe: comparing data in rows and naming according to column names

Thank you.  Very helpful.

Re: comparing data in rows and naming according to column names

Thank you.  This did work for me.  

Re: comparing data in rows and naming according to column names

A little shorter than @MRB3855's answer:

 

Choose( Loc Max( Matrix( {:A, :B, :C} ) ), "A", "B", "C" )

Re: comparing data in rows and naming according to column names

Hi @jackpdavis : This is not as elegant as some folks in this community can come up with, but it works. Put this in for the "highest value" column formula. And make sure the column is a character column.