Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Re: Formula to return value from a row, where row is the Maximum value from a di...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 6, 2018 1:17 PM
(1960 views)

Hi,

I am looking for a formula that does the following:

1) Evaluates the maximum value of a column, by a Grouping Column

2) Once the largest value is found for each "group", I need to return the value in another column corresponding to that row for each "group". Is this possible? This would be so easy in Excel. =( Example below. Thanks a million

Grouping | Column for Return | Column to Eval Max | Output Column with Miracle Formula |

1 | 25 | 23000 | |

1 | 26 | 25000 | |

1 | 27 | 30000 | 27 |

1 | 28 | 10000 | |

1 | 29 | 25 | |

2 | 25 | 1 | |

2 | 26 | 2 | |

2 | 27 | 3 | |

2 | 28 | 4 | |

2 | 29 | 5 | 29 |

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Does this work for you:

If( Col Max( :Column to Eval Max, :Grouping ) == :Column to Eval Max,

:Column for Return

)

2 REPLIES 2

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Does this work for you:

If( Col Max( :Column to Eval Max, :Grouping ) == :Column to Eval Max,

:Column for Return

)

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Formula to return value from a row, where row is the Maximum value from a different column

That does the trick. Thanks, Jerry--you really made my day.