Getting MIN value for a string in a list

  • Thread starter Thread starter dougmcc1
  • Start date Start date
D

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
 
=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)
 
Thanks!

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

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

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