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

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Answer to: test/ hyperlink to an Error in a column 3
Formula structure, maybe not parenthesis, CELL()? 1
How to find a result in an array in the same row as a minimum resu 3
In part of a col of data, I need the minimum number, but exclude z 10
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Lookup in a matrix (with x and y headings) based on value x and y 2
returning a specific cell value 2
Analysis of measured test results by INTERVAL (variable) 2

Top