IF evaluations & collapse result column

Storyman · General User Joined: 09 Jun 2009 Posts: 7

Spreadsheets have been a struggle, yet I've managed to get done what is needed--until now. Your help is appreciated.

Column 'C' has mostly empty cells and a few have the value "Yes".

When a cell in column 'C' has the value of "Yes", I'd like to grab the content in column 'A' and put it in another cell. Ultimately, there would be a neat stack of items from column 'A' that also have a corresponding value of "Yes" in column 'C'.

Using an IF and CONTENT statements would work except for one thing. The range is over 80 cells, but only 12 cells in that range have the value of "Yes". My skill level would leave me with a column where the values are scattered in an 80 cell column instead of a neat stack.

Is something like this even possible?

David · Posted: Sun Jun 14, 2009 6:01 am Post subject:

First use your IF, but you don't need Content. Then Filter the results.

=IF(C1="Yes";A1;"") copy down the column.

Now, look at the Data Sort and Filter options in the top menu. You can cut out the rows not needed and view only those that are, or list them according to that content.

David.

Storyman · General User Joined: 09 Jun 2009 Posts: 7

Hi David,

Thank you for the feedback.

I guess the best thing to do is to have the output on a separate worksheet that is then collapsed and imported onto the main worksheet.

David · Posted: Sun Jun 14, 2009 12:05 pm Post subject:

Storyman · General User Joined: 09 Jun 2009 Posts: 7

Hi David,

Chalk it up as a 'Duh!' moment for me.

Thanks again.