min value

C

ceemo

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
 
C

ceemo

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))
 
C

ceemo

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))
 
Top