OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

IF evaluations & collapse result column

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Storyman
General User
General User


Joined: 09 Jun 2009
Posts: 7

PostPosted: Sat Jun 13, 2009 8:27 pm    Post subject: IF evaluations & collapse result column Reply with quote

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?
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Jun 14, 2009 6:01 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Storyman
General User
General User


Joined: 09 Jun 2009
Posts: 7

PostPosted: Sun Jun 14, 2009 6:50 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Jun 14, 2009 12:05 pm    Post subject: Reply with quote

Storyman wrote:
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.


If you sort it then it is already "collapsed" into its various groups. If you want to, you can delete unwanted rows then print that [without re-saving, so as to not write over the original file.

David.
Back to top
View user's profile Send private message
Storyman
General User
General User


Joined: 09 Jun 2009
Posts: 7

PostPosted: Sun Jun 14, 2009 12:11 pm    Post subject: Reply with quote

Hi David,

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

Thanks again.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group