Do a MIN of a range of cells when they have a given value

[GusAlmeida]

Let's say I have:


A B
John 100
Bob 200
Anne 50
Bob 300
John 150
John 75

I want to do the =MIN in column B for each value of column A (so 1, 2, 3).

For John would be 75, for Bob 200 and for Anne 50.

Thanks in advance.

[Ace_XL]

Use this array formula

=MIN(IF(A1:A10="John",B1:B10))

Confirm with Ctrl+Shift+Enter

Change John to Bob, Anne etc for varying results or use a cell reference for the name

[GusAlmeida]

THanks very much Ace_XL! It worked beautifully.