N
nastech
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),BU681:BU1159,0))
not working, get FALSE, need row number of next "min" numbe
=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"))
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),BU681:BU1159,0))
not working, get FALSE, need row number of next "min" numbe
=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"))