BookmarkSubscribe
Choose Language Hide Translation Bar
Community Trekker

## 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

 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
Staff (Retired)

## 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 2
Staff (Retired)

## 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
Community Trekker

## 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.