Returning a set of instances (array formulas)

Hello,

I have a large column of text, Column A. In B, I have a formula that returns a "1" whenever a certain text is found. There are 60 instances in column B where a 1 is displayed. So far so good. Now, I would like to display all of the cells in column A where a 1 was found in Column B.

So, A has about 900 cells of text, B has 60 "1"s scattered about, and C should be filled with 60 cells based on where the "1"s where displayed.

Sorry if that didn't come out too clear.

This regular formula will list the Col_A items, in the order encountered, where the corresponding Col_B value equals 1:

Please Login or Register  to view this content.

Copy that formula down as far as you need.

Is that something you can work with?

you can't have any text in column B, not even a space -- for example if you have a formula that says [ if(celll=x,1,"") ] that "" would constitute a space

If you post a workbook with representative data, we'll be able to see what you're working with.

Another thought...(triggered by TR's comment):
try this:

Please Login or Register  to view this content.

Yes...In my scenario, Col_B contained 1's and 0's. Your scenario contained 1's and empty text (""). The empty text cannot convert to a number, hence the error.

When I change the INDEX section of the SMALL function to use:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

The error was handled.