Getting MIN value for a string in a list

[dougmcc1]

I have 2 lists. List A is just a set of strings. List B is a set of the
same strings with multiplae values associated to them. For List A, how
do I return the minimum value for the same string in List B?

Example:

List A
string1
string2
string3

List B
string1 3
string1 6
string1 2
string2 10
string2 5
string2 2
string3 4
string3 5

 

[Bob Phillips]

=MIN(IF(B2:B20="string1",C2:C20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[dougmcc1]

Thanks!

What do you mean by "it should be committed" and why use
cntrl+shift+enter instead of just enter?

 

[David Biddulph]

Thanks!

What do you mean by "it should be committed" and why use
cntrl+shift+enter instead of just enter?

Look at "array formula" in Excel's help.