View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default test for minimum #, exlude line with "x" in a column.

060809 test for minimum #, exlude line with "x" in a column.

hi, I am trying to test a range for the minimum number, but to exclude rows
that have an "x" in a specific problem. thanks.

starting with:
=INDEX(ROW(BU681:BU1159),MATCH(MIN(BU681:BU1159),B U681:BU1159,0))

not working, get FALSE, need row number of next "min" number
=AND(G681:G1159<"x",INDEX(ROW(BU681:BU1159),MATCH (MIN(BU681:BU1159),BU681:BU1159,0)))

similar equation have working is:
=SUMPRODUCT(--(LEFT($AX$56:$AX$1159,1)="x"),--($G$56:$G$1159<"x"))