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

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

M0gAl0g — Wed, 06 Jun 2018 20:17:01 GMT

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

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

jerry_cooper — Wed, 06 Jun 2018 20:43:38 GMT

Does this work for you:

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

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

M0gAl0g — Thu, 07 Jun 2018 00:59:14 GMT

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