[Solved] Find largest conditional value

[Alexie]

Hi,

I have come across a problem which I cannot seem to solve on my own. I have the following situation:
ID Value
A 1.5
A 1.5
B 2.5
A 4

And I would like to select the largest value for a given value:
ID Value
A 4
B 2.5

Any suggestions to achieve this by code?
Thanks in advance

[FJCC]

One way to do this is with a Pivot Table (menu item Data -> Pivot Table). Right click on the table in the attached document and select Edit Layout to see how I set it up. You can double click on the item that says Max Value to see other options for calculating statistical properties of the Value column.

[FJCC]

You can also use an array formula. Enter the formula

Code: Select all

=MAX(IF(A2:A10 = "a";B2:B10;""))

but finish by pressing CTRL+Shift+Enter. The formula will then be enclosed in curly braces {}.

[Zizi64]

Similar topic:
viewtopic.php?t=88118&p=413996

[Alexie]

I tried the suggested solution in the above thread.
It works! Many thanks for your replies!