Eliminating Blank rows

[Lversteeg]

I am hoping someone can help me!!!!

I have on one sheet a product selector for my sales team. I have added a

 

[Bernie Deitrick]

In cell A1, array enter (enter using Ctrl-Shift-Enter) the formula

=INDEX(ProductSelector!$I:$I,SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1)))

and copy down.

You can hide the error values by using this slightly more complicated version:

=IF(COUNTIF(ProductSelector!R:R,"X")>=ROWS($B$1:B1),INDEX(ProductSelector!$I:$I,
SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1))),"")

HTH,
Bernie
MS Excel MVP

 

[Lversteeg]

Thanks Bernie, I can't get it to calculate correctly though. The Product
Selector has a completely different layout than the Quote and I only want
certain information for there to be taken to the quote. And when I get to the
prices there are too many IF's to incorporate the formula that you sent me.

Thanks anyway

 

[Bernie Deitrick]

Post a little bit of your data, and describe what you would want returned.

Bernie