Look up for a max or min value

[Timmy Mac1]

Here's what I'm trying to achieve...

if COL A contains various terms
if COL B contains associated values

I'm trying to get a formula in COL C that will tell me if the value in COL B is equal to the maximum (or minimum) value for the corresponding term in COL A.

eg if COL A = a,b,c,a
and COL B = 1,2,3,4

I want COL C to return (assuming I'm after the maximum)

FALSE, TRUE, TRUE, TRUE

Can anyone assist?

Thanks

Timmymac

[Domenic]

Try...

C1, copied down:

=B1=MAX(IF($A$1:$A$4=A1,$B$1:$B$4))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

[Timmy Mac1]

Domenic

thanks very much. I'm not an array formula afficianado but you're formula is doing the business for me