Using array enter (Ctrl+Shift+Enter), you can try this:
{=MIN(IF(A$1:A$10=D1,B$1:B$10,""))}
{=MAX(IF(A$1:A$10=D1,B$1:B$10,""))}
Hope this helps.
ceemo Wrote:
I have a list of names in Column A and in Column B is a number that
corrospondes to the name. The name may appear more than once.
In column D is a list of th unique names in column E i would like a
formula that auto puts the minimum number corrosponding to the name. In
Column F i would like a formula to auto put in the max value that
corrospondes with that name.
Hope not to confusing, Can anyone help?
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=394272