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