Using the MAX Function

  • Thread starter Thread starter RFJ
  • Start date Start date
R

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
 
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
 
Back
Top