|
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")) |
test for minimum #, exlude line with "x" in a column.
in a specific column, that is..
"nastech" wrote: 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")) |
| All times are GMT +1. The time now is 09:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com