i would like to fidn the minimum number value of column h where column i
is equal to c6. once i have this i will add in an is error where there
is no value equal to c6 in column i


=minproduct(--(I6:I13=C6),H6:H13)

i tried this but with no joy


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