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

i managed to get the below to work

=MAX(IF(J$9:J$1000=B9,I$9:I$1000))


id like to adapt this to include two criteria's like so but tis doesnt
seem to work

=MAX(IF(AND(J$9:J$1000=B9,L$9:L$1000=1),I$9:I$1000 ))


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

i managed to get the below to work

=MAX(IF(J$9:J$1000=B9,I$9:I$1000))


id like to adapt this to include two criteria's like so but tis doesnt
seem to work

=MAX(IF(AND(J$9:J$1000=B9,L$9:L$1000=1),I$9:I$1000 ))


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

dont worry sorted this know,


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