Help Please - Formula Almost Works

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

Joe Gieder

Any ideas from anyone would be greatly appreciated. Thanks

I tried posting in the same thread but since this was
several days ago it wasn't answered.

Thanks Peo.
It works except now if the item ($I$1:$I$733) contains a
letter it skips it. Any ideas?
Joe
-----Original Message-----
Without testing the formula, would this work?

=IF(ISERR(SMALL(IF(('Priced BOM'!$X$3:$X$733>19)* (ISNUMBER('Priced
("'Priced
BOM'!$I$1:$I$733"),SMALL(IF(('Priced BOM'!$X$3:$X$733>19) *(ISNUMBER('Priced
BOM'!$X$3:$X$733)),ROW('Priced BOM'!$X$3:$X$733)),ROW()- ROW($I$5)+1)))

--

Regards,

Peo Sjoblom





.
Click to expand...
..
 
I thought that was what you wanted?

"Right now it also includes results that are alphabetic."

what did you mean by that? Now you say:

"It works except now if the item ($I$1:$I$733) contains a
letter it skips it."

If you just want to avoid lines in I where X is "stk" try

('Priced BOM'!$X$3:$X$733<>"STK")

instead of the isnumber part
 
Back
Top