Using the MAX Function

[RFJ]

I want to set up a function that looks for a value in the first column and
identifies the associated MAX value in the second. (eg in relation to the
data below the Max Value for B is 43) Can SKS help out. TIA


A 1
B 9
C 12
A 23
B 43
C 21
B 13
C 12
B 11
C 11

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER) in C1:
=MAX(IF($A$1:$A$100=A1,$B$1:$B$100))
and copy down