select min value in B column for same values in A columns excel? -

select min value in B column for same values in A columns excel? -

i e.g. min or max value column2 same value in column1. in mine illustration want max value column2 value (column1) , 18, , b 27.

i've tried array function cannot manage work properly.

tnx tip or solution.

example:

column1 column2 max_value 1 18 5 18 18 18 3 18 4 18 b 2 27 b 5 27 b 18 27 b 27 27 b 5 27 b 3 27

sorry poor example, couldn't post picture, rank not high plenty :)

the standard "array formula" c2

=max(if(a$2:a$100=a2,b$2:b$100))

confirmed ctrl+shift+enter , copied downwards column - adjust ranges required

replace max min minimum values in next column

excel