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.
Bookmarks