Help Refining Formula

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
 
Top