- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.)
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: comparing data in rows and naming according to column names
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: comparing data in rows and naming according to column names
Thank you. Very helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: comparing data in rows and naming according to column names
Thank you. This did work for me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: comparing data in rows and naming according to column names
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: comparing data in rows and naming according to column names
Thank you. Very helpful.