Getting MIN value for a string in a list
 

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


--
dougmcc1
------------------------------------------------------------------------
dougmcc1's Profile: http://www.excelforum.com/member.php...info&userid=85
View this thread: http://www.excelforum.com/showthread...hreadid=554116

Getting MIN value for a string in a list
 

=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" wrote in
message ...

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


--
dougmcc1
------------------------------------------------------------------------
dougmcc1's Profile:
http://www.excelforum.com/member.php...info&userid=85
View this thread: http://www.excelforum.com/showthread...hreadid=554116

Getting MIN value for a string in a list
 

Thanks!

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


--
dougmcc1
------------------------------------------------------------------------
dougmcc1's Profile: http://www.excelforum.com/member.php...info&userid=85
View this thread: http://www.excelforum.com/showthread...hreadid=554116

Getting MIN value for a string in a list
 

"dougmcc1" wrote in
message ...

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.
--
David Biddulph