View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dougmcc1
 
Posts: n/a
Default 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