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.
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.
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
Life's a spreadsheet, Excel!
Say thanks, Click *
THanks very much Ace_XL! It worked beautifully.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks