Lookup and return the max Value

[Peter]

A 1
B 1
C 1
A 2
B 2
C 2
B 3
C 3

My data is laid out in 2 columns as above. Column A
contains names which are repeated; in this case A to C.
Column B contains values. Could anyone help me with a
function to return the highest value from column B
associated with a name in column A. For example the
highest value for A would be 2 and the highest value for B
would be 3.
It is likely that the solution will contain an array so
could you also please explain the CTRL+SHIFT+RETURN
associated with arrays

Thank you in advance
Peter

 

[Dave R.]

This will do that;

=MAX(IF(A1:A8="A",B1:B8))

type the formula in as you normally would, except instead of simply pressing
"enter", press CTRL SHIFT and ENTER at once, and the formula will then
appear with { } around it if you've done it right.