Hello Guru's,
I am in need of assistance once more. I would like to be able to return my entire list with the exceptions of "BOEING", "CREW SEATS", AND "CENTER BAY" rows. barry houdini helped me fix up the following array formula to return these three and I may be beating a dead horse with the same formula but I believe index/small is the way to go when compiling a list of similar items. Please help me if at all possible possible. My wife would say it isn't but you never know.
=IF(ISERROR(INDEX(SPARES!$A$1:$O$300,SMALL(IF(LEFT(SPARES!$A$1:$O$300,6)="BOEING",ROW(SPARES!$A$1:$O$300)),ROW(1:1)),2)),"",INDEX(SPARES!$A$1:$O$300,SMALL(IF(LEFT(SPARES!$A$1:$O$300,6)="BOEING",ROW(SPARES!$A$1:$O$300)),ROW(1:1)),2))
I am in need of assistance once more. I would like to be able to return my entire list with the exceptions of "BOEING", "CREW SEATS", AND "CENTER BAY" rows. barry houdini helped me fix up the following array formula to return these three and I may be beating a dead horse with the same formula but I believe index/small is the way to go when compiling a list of similar items. Please help me if at all possible possible. My wife would say it isn't but you never know.
=IF(ISERROR(INDEX(SPARES!$A$1:$O$300,SMALL(IF(LEFT(SPARES!$A$1:$O$300,6)="BOEING",ROW(SPARES!$A$1:$O$300)),ROW(1:1)),2)),"",INDEX(SPARES!$A$1:$O$300,SMALL(IF(LEFT(SPARES!$A$1:$O$300,6)="BOEING",ROW(SPARES!$A$1:$O$300)),ROW(1:1)),2))
