J
Joe Gieder
I have the following formula:
=IF(ISERR(SMALL(IF('Priced BOM'!$X$3:$X$733>19,ROW
('Priced BOM'!$X$3:$X$733)),ROW()-ROW($I$5)+1)),"",INDEX
(INDIRECT("'Priced BOM'!$I$1:$I$733"),SMALL(IF('Priced
BOM'!$X$3:$X$733>19,ROW('Priced BOM'!$X$3:$X$733)),ROW()-
ROW($I$5)+1))) - Array Entered
What I'm trying to do (without using autofilter because
two different worksheets are involved and I'm trying to
eliminate as many additional steps as possible) is get
all the items with a delivery of over 19. This formula
works with the exception that it also includes items that
say "stk" in place of a number. Is there a way to modify
this formula to not include the "STK" items.
TIA for all the help
Joe
=IF(ISERR(SMALL(IF('Priced BOM'!$X$3:$X$733>19,ROW
('Priced BOM'!$X$3:$X$733)),ROW()-ROW($I$5)+1)),"",INDEX
(INDIRECT("'Priced BOM'!$I$1:$I$733"),SMALL(IF('Priced
BOM'!$X$3:$X$733>19,ROW('Priced BOM'!$X$3:$X$733)),ROW()-
ROW($I$5)+1))) - Array Entered
What I'm trying to do (without using autofilter because
two different worksheets are involved and I'm trying to
eliminate as many additional steps as possible) is get
all the items with a delivery of over 19. This formula
works with the exception that it also includes items that
say "stk" in place of a number. Is there a way to modify
this formula to not include the "STK" items.
TIA for all the help
Joe