| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
Threaded Mode
