=min(if(
 

Im after a formula to put in min column that will look up the unique
column in the name column and present the minimummatching number

Name No. Unique Min
Jen 4 Jen ?
Jon 6 Jon ?
Ray 7 Ray ?
For 8 For ?
Jick 4 Jick ?
Yen 5 Yen ?
Ray 4 bob ?
bob 12 hick ?
for 5 jen ?
hick 45
jen 2


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=394318

Is it a typo that you have 2 "jen" in the unique column?

Anyway try this *array* formula in D2, and copy down as needed:

=MIN(IF($A$2:$A$12=C2,$B$2:$B$12))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"ceemo" wrote in
message ...

Im after a formula to put in min column that will look up the unique
column in the name column and present the minimummatching number

Name No. Unique Min
Jen 4 Jen ?
Jon 6 Jon ?
Ray 7 Ray ?
For 8 For ?
Jick 4 Jick ?
Yen 5 Yen ?
Ray 4 bob ?
bob 12 hick ?
for 5 jen ?
hick 45
jen 2


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=394318