BookmarkSubscribeRSS Feed
M0gAl0g

Occasional Contributor

Joined:

May 16, 2018

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

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

 

GroupingColumn for ReturnColumn to Eval MaxOutput Column with Miracle Formula
12523000 
12625000 
1273000027
12810000 
12925 
2251 
2262 
2273 
2284 
229529
1 ACCEPTED SOLUTION

Accepted Solutions
jerry_cooper

Staff

Joined:

Jul 10, 2014

Solution

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

Does this work for you:

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

 

2 REPLIES
jerry_cooper

Staff

Joined:

Jul 10, 2014

Solution

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

Does this work for you:

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

 

Highlighted
M0gAl0g

Occasional Contributor

Joined:

May 16, 2018

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.